eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CTO_GOP_INTERFACE_PK dependencies on FND_API

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: BEGIN
106:
107: oe_debug_pub.add(' START TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111:
112: lStmtNum := 10;
113: DELETE FROM bom_cto_order_lines_gt;

Line 241: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

237: x_return_status => x_return_status,
238: x_msg_count => X_msg_count,
239: x_msg_data => X_msg_data
240: );
241: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
242: --level 1
243: -- IF PG_DEBUG <> 0 THEN
244: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
245: -- END IF;

Line 246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

242: --level 1
243: -- IF PG_DEBUG <> 0 THEN
244: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
245: -- END IF;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE fnd_api.g_exc_error;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE fnd_api.g_exc_unexpected_error;
250: END IF;

Line 247: RAISE fnd_api.g_exc_error;

243: -- IF PG_DEBUG <> 0 THEN
244: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
245: -- END IF;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE fnd_api.g_exc_error;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE fnd_api.g_exc_unexpected_error;
250: END IF;
251:

Line 248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

244: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.prepare_bcol_temp_data',1);
245: -- END IF;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE fnd_api.g_exc_error;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE fnd_api.g_exc_unexpected_error;
250: END IF;
251:
252:

Line 249: RAISE fnd_api.g_exc_unexpected_error;

245: -- END IF;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE fnd_api.g_exc_error;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE fnd_api.g_exc_unexpected_error;
250: END IF;
251:
252:
253: IF l_PDS_ODS = 4 THEN --PDS

Line 287: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

283: X_return_status =>x_return_status,
284: X_msg_count =>x_msg_count,
285: X_msg_data =>x_msg_data
286: ) ;
287: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
288: -- IF PG_DEBUG <> 0 THEN
289: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
290: -- END IF;
291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

287: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
288: -- IF PG_DEBUG <> 0 THEN
289: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
290: -- END IF;
291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE fnd_api.g_exc_error;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;

Line 292: RAISE fnd_api.g_exc_error;

288: -- IF PG_DEBUG <> 0 THEN
289: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
290: -- END IF;
291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE fnd_api.g_exc_error;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296: end if; --lReuseProfile = 1 Bugfix 6642016

Line 293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

289: oe_debug_pub.add('SUCCESS after CTO_MATCH_CONFIG.CTO_REUSE_CONFIGURATION',1);
290: -- END IF;
291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE fnd_api.g_exc_error;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296: end if; --lReuseProfile = 1 Bugfix 6642016
297:

Line 294: RAISE fnd_api.g_exc_unexpected_error;

290: -- END IF;
291: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE fnd_api.g_exc_error;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296: end if; --lReuseProfile = 1 Bugfix 6642016
297:
298: IF l_match_profile = 1 THEN

Line 314: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

310: p_cto_match_rec => p_match_rec_of_tab
311:
312: );
313:
314: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
315: IF PG_DEBUG <> 0 THEN
316: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
317: END IF;
318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

314: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
315: IF PG_DEBUG <> 0 THEN
316: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
317: END IF;
318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE fnd_api.g_exc_error;
320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;

Line 319: RAISE fnd_api.g_exc_error;

315: IF PG_DEBUG <> 0 THEN
316: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
317: END IF;
318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE fnd_api.g_exc_error;
320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;
323:

Line 320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

316: oe_debug_pub.add('SUCCESS after CTO_Configured_Item_GRP.MATCH_CONFIGURED_ITEM',1);
317: END IF;
318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE fnd_api.g_exc_error;
320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;
323:
324: END IF; -- l_match_pfoile = 1

Line 321: RAISE fnd_api.g_exc_unexpected_error;

317: END IF;
318: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE fnd_api.g_exc_error;
320: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE fnd_api.g_exc_unexpected_error;
322: END IF;
323:
324: END IF; -- l_match_pfoile = 1
325:

Line 365: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

361: X_MSG_DATA =>X_msg_data,
362: X_MSG_COUNT =>X_msg_count
363: );
364:
365: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
366: --level 1
367: -- IF PG_DEBUG <> 0 THEN
368: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
369: -- END IF;

Line 370: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

366: --level 1
367: -- IF PG_DEBUG <> 0 THEN
368: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
369: -- END IF;
370: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
371: RAISE fnd_api.g_exc_error;
372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;

Line 371: RAISE fnd_api.g_exc_error;

367: -- IF PG_DEBUG <> 0 THEN
368: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
369: -- END IF;
370: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
371: RAISE fnd_api.g_exc_error;
372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:

Line 372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

368: oe_debug_pub.add('SUCCESS after CTO_OSS_SOURCE_PK.GET_OSS_ORGS_LIST',1);
369: -- END IF;
370: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
371: RAISE fnd_api.g_exc_error;
372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:
376: --make sure floowling sql bring null values too

Line 373: RAISE fnd_api.g_exc_unexpected_error;

369: -- END IF;
370: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
371: RAISE fnd_api.g_exc_error;
372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:
376: --make sure floowling sql bring null values too
377: lStmtNum:=90;

Line 468: WHEN fnd_api.g_exc_error THEN

464:
465: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
466:
467: EXCEPTION
468: WHEN fnd_api.g_exc_error THEN
469: IF PG_DEBUG <> 0 THEN
470: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '
471: || to_char(lStmtNum), 1);
472: END IF;

Line 473: x_return_status := FND_API.G_RET_STS_ERROR;

469: IF PG_DEBUG <> 0 THEN
470: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Exception in stmt num: '
471: || to_char(lStmtNum), 1);
472: END IF;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Get message count and data
475: cto_msg_pub.count_and_get
476: ( p_msg_count => x_msg_count
477: , p_msg_data => x_msg_data

Line 479: WHEN fnd_api.g_exc_unexpected_error THEN

475: cto_msg_pub.count_and_get
476: ( p_msg_count => x_msg_count
477: , p_msg_data => x_msg_data
478: );
479: WHEN fnd_api.g_exc_unexpected_error THEN
480: IF PG_DEBUG <> 0 THEN
481: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '
482: || to_char(lStmtNum), 1);
483: END IF;

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

480: IF PG_DEBUG <> 0 THEN
481: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || ' Unexpected Exception in stmt num: '
482: || to_char(lStmtNum), 1);
483: END IF;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
485: -- Get message count and data
486: cto_msg_pub.count_and_get
487: ( p_msg_count => x_msg_count
488: , p_msg_data => x_msg_data

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: oe_debug_pub.add('CTO_GOP_WRAPPER_API: ' || 'Others Exception in stmt num: '
493: || to_char(lStmtNum), 1);
494: oe_debug_pub.add('error='||sqlerrm);
495: END IF;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: -- Get message count and data
498: cto_msg_pub.count_and_get
499: ( p_msg_count => x_msg_count
500: , p_msg_data => x_msg_data