DBA Data[Home] [Help]

APPS.PSB_EXCEL_PVT dependencies on FND_MSG_PUB

Line 174: FND_MSG_PUB.initialize ;

170: END IF;
171: --
172:
173: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
174: FND_MSG_PUB.initialize ;
175: END IF;
176: --
177: p_return_status := FND_API.G_RET_STS_SUCCESS ;
178:

Line 204: FND_MSG_PUB.Add;

200:
201: IF NOT l_ws_rec_found THEN
202: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
203: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Export Worksheet Procedure' );
204: FND_MSG_PUB.Add;
205: RAISE FND_API.G_EXC_ERROR ;
206: END IF;
207:
208: g_worksheet_id := p_worksheet_id;

Line 249: FND_MSG_PUB.Add;

245: IF ( not l_export_accounts) AND
246: ( not l_export_positions) THEN
247: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
248: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Export Worksheet Procedure' );
249: FND_MSG_PUB.Add;
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252:
253: -- Set the correct worksheet type

Line 364: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

360: WHEN FND_API.G_EXC_ERROR THEN
361:
362: ROLLBACK TO Move_To_Interface_Pvt;
363: p_return_status := FND_API.G_RET_STS_ERROR;
364: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
365: p_data => p_msg_data );
366: --
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368:

Line 371: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368:
369: ROLLBACK TO Move_To_Interface_Pvt;
370: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
372: p_data => p_msg_data );
373: --
374: WHEN OTHERS THEN
375: ROLLBACK TO Move_To_Interface_Pvt;

Line 378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

374: WHEN OTHERS THEN
375: ROLLBACK TO Move_To_Interface_Pvt;
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: --
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
380: l_api_name);
381: END if;
382: --

Line 379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

375: ROLLBACK TO Move_To_Interface_Pvt;
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: --
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
380: l_api_name);
381: END if;
382: --
383: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 383: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
380: l_api_name);
381: END if;
382: --
383: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
384: p_data => p_msg_data );
385: --
386:
387: END Move_To_Interface;

Line 3034: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

3030: delete from PSB_ERROR_MESSAGES
3031: where source_process = p_source_process
3032: and process_id = g_msg_export_id;
3033:
3034: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
3035: p_data => l_msg_buf );
3036:
3037:
3038:

Line 3061: FND_MSG_PUB.initialize;

3057: fnd_message.set_name('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');
3058: --
3059: end if;
3060:
3061: FND_MSG_PUB.initialize;
3062:
3063:
3064: END Log_Messages;
3065: /*---------------------------------------------------------------------------*/

Line 3195: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3191: WHEN OTHERS THEN
3192: --
3193: ROLLBACK TO Move_To_Inter_CP_Pvt ;
3194: --
3195: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3196: --
3197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3198: l_api_name ) ;
3199: END IF ;

Line 3197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

3193: ROLLBACK TO Move_To_Inter_CP_Pvt ;
3194: --
3195: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3196: --
3197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3198: l_api_name ) ;
3199: END IF ;
3200: --
3201: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3304: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3300: WHEN OTHERS THEN
3301: --
3302: ROLLBACK TO Move_To_PSB_CP_Pvt ;
3303: --
3304: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3305: --
3306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3307: l_api_name ) ;
3308: END IF ;

Line 3306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

3302: ROLLBACK TO Move_To_PSB_CP_Pvt ;
3303: --
3304: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3305: --
3306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3307: l_api_name ) ;
3308: END IF ;
3309: --
3310: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 3365: FND_MSG_PUB.initialize ;

3361: END IF;
3362: --
3363:
3364: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
3365: FND_MSG_PUB.initialize ;
3366: END IF;
3367: --
3368: p_return_status := FND_API.G_RET_STS_SUCCESS ;
3369:

Line 3391: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3387: WHEN FND_API.G_EXC_ERROR THEN
3388:
3389: ROLLBACK TO Del_Worksheet_Pvt;
3390: p_return_status := FND_API.G_RET_STS_ERROR;
3391: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3392: p_data => p_msg_data );
3393: --
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395:

Line 3398: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395:
3396: ROLLBACK TO Del_Worksheet_Pvt;
3397: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3398: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3399: p_data => p_msg_data );
3400: --
3401: WHEN OTHERS THEN
3402: ROLLBACK TO Del_Worksheet_Pvt;

Line 3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3401: WHEN OTHERS THEN
3402: ROLLBACK TO Del_Worksheet_Pvt;
3403: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3404: --
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3406: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3407: l_api_name);
3408: END if;
3409: --

Line 3406: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3402: ROLLBACK TO Del_Worksheet_Pvt;
3403: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3404: --
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3406: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3407: l_api_name);
3408: END if;
3409: --
3410: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 3410: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

3406: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3407: l_api_name);
3408: END if;
3409: --
3410: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
3411: p_data => p_msg_data );
3412: --
3413:
3414: END Del_Worksheet;

Line 3499: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3495: WHEN OTHERS THEN
3496: --
3497: ROLLBACK TO Del_Worksheet_CP_Pvt ;
3498: --
3499: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3500: --
3501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3502: l_api_name ) ;
3503: END IF ;

Line 3501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

3497: ROLLBACK TO Del_Worksheet_CP_Pvt ;
3498: --
3499: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3500: --
3501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3502: l_api_name ) ;
3503: END IF ;
3504: --
3505: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,