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.

APPS.CTO_MATCH_CONFIG dependencies on FND_API

Line 212: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

208:
209: gUserId := nvl(Fnd_Global.USER_ID, -1) ;
210: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
211:
212: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
213:
214:
215: IF PG_DEBUG <> 0 THEN
216: oe_debug_pub.add('match_and_create_all_items: ' || 'In Match_and_Create_all_Items for ato_line_id '

Line 268: raise fnd_api.g_exc_error;

264: END IF;
265:
266: if (lStatus = 0) then
267:
268: raise fnd_api.g_exc_error;
269:
270: elsif lStatus =1 then
271: --start bugfix 3070429,3124169
272:

Line 289: --return status passed as 'S' and not as FND_API.XXXXX

285: x_msg_count => xMsgCount,
286: x_msg_data => xMsgData);
287:
288:
289: --return status passed as 'S' and not as FND_API.XXXXX
290: --CTO has decided not to fail for error messages but just log messages
291: --refer bug 3124169 for more info
292: IF eni_return_status = 'S' THEN
293: IF PG_DEBUG <> 0 THEN

Line 341: raise fnd_api.g_exc_error;

337: end;
338:
339: else
340:
341: raise fnd_api.g_exc_error;
342:
343: end if; -- end lStatus = 1
344:
345: else

Line 364: raise fnd_api.g_exc_error;

360: || to_char(lStatus), 1);
361: END IF;
362:
363: if lStatus <> 1 then
364: raise fnd_api.g_exc_error;
365: end if;
366: ELSE
367: IF PG_DEBUG <> 0 THEN
368: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);

Line 383: raise fnd_api.g_exc_error;

379: || to_char(lStatus), 1);
380: END IF;
381:
382: if lStatus <> 1 then
383: raise fnd_api.g_exc_error;
384: end if;
385:
386: END IF;
387:

Line 412: raise fnd_api.g_exc_error;

408: END IF;
409:
410: if (lStatus <> 1) then
411:
412: raise fnd_api.g_exc_error;
413:
414: else
415: --start bugfix 3070429,3124169
416:

Line 432: --return status passed as 'S' and not as FND_API.XXXXX

428: x_msg_count => xMsgCount,
429: x_msg_data => xMsgData);
430:
431:
432: --return status passed as 'S' and not as FND_API.XXXXX
433: --CTO has decided not to fail for error messages but just log messages
434: --refer bug 3124169 for more info
435: IF eni_return_status = 'S' THEN
436: IF PG_DEBUG <> 0 THEN

Line 473: raise fnd_api.g_exc_error;

469: END IF;
470:
471: if (lStatus <> 1) then
472:
473: raise fnd_api.g_exc_error;
474: end if;
475:
476: begin
477:

Line 517: raise fnd_api.g_exc_error;

513: END IF;
514:
515: if (lStatus = 0) then
516:
517: raise fnd_api.g_exc_error;
518:
519: else
520: --start bugfix 3070429,3124169
521:

Line 538: --return status passed as 'S' and not as FND_API.XXXXX

534: x_msg_count => xMsgCount,
535: x_msg_data => xMsgData);
536:
537:
538: --return status passed as 'S' and not as FND_API.XXXXX
539: --CTO has decided not to fail for error messages but just log messages
540: --refer bug 3124169 for more info
541: IF eni_return_status = 'S' THEN
542: IF PG_DEBUG <> 0 THEN

Line 561: raise fnd_api.g_exc_error;

557: end if;
558:
559: else
560:
561: raise fnd_api.g_exc_error;
562:
563: end if; -- end lStatus = 1 and lXConfigID is not null
564:
565: end if; -- end lNextRec.Perform_match

Line 582: WHEN fnd_api.g_exc_error THEN

578: );
579:
580: EXCEPTION
581:
582: WHEN fnd_api.g_exc_error THEN
583: IF PG_DEBUG <> 0 THEN
584: oe_debug_pub.add('match_and_create_all_items: ' || 'Exception in stmt num: ' || to_char(lStmtNum), 1);
585: END IF;
586: xReturnStatus := FND_API.G_RET_STS_ERROR;

Line 586: xReturnStatus := FND_API.G_RET_STS_ERROR;

582: WHEN fnd_api.g_exc_error THEN
583: IF PG_DEBUG <> 0 THEN
584: oe_debug_pub.add('match_and_create_all_items: ' || 'Exception in stmt num: ' || to_char(lStmtNum), 1);
585: END IF;
586: xReturnStatus := FND_API.G_RET_STS_ERROR;
587: -- Get message count and data
588: cto_msg_pub.count_and_get
589: ( p_msg_count => xMsgCount
590: , p_msg_data => xMsgData

Line 592: WHEN fnd_api.g_exc_unexpected_error THEN

588: cto_msg_pub.count_and_get
589: ( p_msg_count => xMsgCount
590: , p_msg_data => xMsgData
591: );
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: IF PG_DEBUG <> 0 THEN
594: oe_debug_pub.add('match_and_create_all_items: ' || ' Unexpected Exception in stmt num: ' || to_char(lStmtNum), 1);
595: END IF;
596: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 596: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR ;

592: WHEN fnd_api.g_exc_unexpected_error THEN
593: IF PG_DEBUG <> 0 THEN
594: oe_debug_pub.add('match_and_create_all_items: ' || ' Unexpected Exception in stmt num: ' || to_char(lStmtNum), 1);
595: END IF;
596: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR ;
597: -- Get message count and data
598: cto_msg_pub.count_and_get
599: ( p_msg_count => xMsgCount
600: , p_msg_data => xMsgData

Line 608: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

604: oe_debug_pub.add('errmsg'||sqlerrm);
605: IF PG_DEBUG <> 0 THEN
606: oe_debug_pub.add('match_and_create_all_items: ' || 'Others Exception in stmt num: ' || to_char(lStmtNum), 1);
607: END IF;
608: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
609: -- Get message count and data
610: cto_msg_pub.count_and_get
611: ( p_msg_count => xMsgCount
612: , p_msg_data => xMsgData

Line 1232: x_return_status := FND_API.G_RET_STS_SUCCESS;

1228:
1229: IF PG_DEBUG <> 0 THEN
1230: oe_debug_pub.add('ENTERED xfer_tab_to_rec',1);
1231: END IF;
1232: x_return_status := FND_API.G_RET_STS_SUCCESS;
1233:
1234: lStmtNum :=10;
1235: l_count := p_match_rec_of_tab.LINE_ID.count;
1236:

Line 1286: WHEN fnd_api.g_exc_error THEN

1282:
1283:
1284:
1285: EXCEPTION
1286: WHEN fnd_api.g_exc_error THEN
1287: IF PG_DEBUG <> 0 THEN
1288: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Exception in stmt num: '
1289: || to_char(lStmtNum), 1);
1290: END IF;

Line 1291: x_return_status := FND_API.G_RET_STS_ERROR;

1287: IF PG_DEBUG <> 0 THEN
1288: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Exception in stmt num: '
1289: || to_char(lStmtNum), 1);
1290: END IF;
1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292: -- Get message count and data
1293: cto_msg_pub.count_and_get
1294: ( p_msg_count => x_msg_count
1295: , p_msg_data => x_msg_data

Line 1297: WHEN fnd_api.g_exc_unexpected_error THEN

1293: cto_msg_pub.count_and_get
1294: ( p_msg_count => x_msg_count
1295: , p_msg_data => x_msg_data
1296: );
1297: WHEN fnd_api.g_exc_unexpected_error THEN
1298: IF PG_DEBUG <> 0 THEN
1299: oe_debug_pub.add('xfer_tab_to_rec: ' || ' Unexpected Exception in stmt num: '
1300: || to_char(lStmtNum), 1);
1301:

Line 1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1300: || to_char(lStmtNum), 1);
1301:
1302: END IF;
1303:
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: -- Get message count and data
1306: cto_msg_pub.count_and_get
1307: ( p_msg_count => x_msg_count
1308: , p_msg_data => x_msg_data

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1312: IF PG_DEBUG <> 0 THEN
1313: oe_debug_pub.add('xfer_tab_to_rec: ' || 'Others Exception in stmt num: '
1314: || to_char(lStmtNum), 1);
1315: END IF;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317: oe_debug_pub.add('error mse'||sqlerrm);
1318: -- Get message count and data
1319: cto_msg_pub.count_and_get
1320: ( p_msg_count => x_msg_count

Line 1350: x_return_status := FND_API.G_RET_STS_SUCCESS;

1346:
1347:
1348:
1349: BEGIN
1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351:
1352: lStmtNum := 10;
1353: l_last_idx := p_tab_of_rec.last;
1354: j := p_tab_of_rec.first;

Line 1412: WHEN fnd_api.g_exc_error THEN

1408:
1409:
1410: EXCEPTION
1411:
1412: WHEN fnd_api.g_exc_error THEN
1413: IF PG_DEBUG <> 0 THEN
1414: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Exception in stmt num: '
1415: || to_char(lStmtNum), 1);
1416: END IF;

Line 1417: x_return_status := FND_API.G_RET_STS_ERROR;

1413: IF PG_DEBUG <> 0 THEN
1414: oe_debug_pub.add('xfer_rec_to_tab: ' || 'Exception in stmt num: '
1415: || to_char(lStmtNum), 1);
1416: END IF;
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: -- Get message count and data
1419: cto_msg_pub.count_and_get
1420: ( p_msg_count => x_msg_count
1421: , p_msg_data => x_msg_data

Line 1423: WHEN fnd_api.g_exc_unexpected_error THEN

1419: cto_msg_pub.count_and_get
1420: ( p_msg_count => x_msg_count
1421: , p_msg_data => x_msg_data
1422: );
1423: WHEN fnd_api.g_exc_unexpected_error THEN
1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add('xfer_rec_to_tab: ' || ' Unexpected Exception in stmt num: ' ||
1426: to_char(lStmtNum), 1);
1427: END IF;

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1424: IF PG_DEBUG <> 0 THEN
1425: oe_debug_pub.add('xfer_rec_to_tab: ' || ' Unexpected Exception in stmt num: ' ||
1426: to_char(lStmtNum), 1);
1427: END IF;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1429: -- Get message count and data
1430: cto_msg_pub.count_and_get
1431: ( p_msg_count => x_msg_count
1432: , p_msg_data => x_msg_data

Line 1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1437: to_char(lStmtNum), 1);
1438: oe_debug_pub.add('errmessage' || sqlerrm,1);
1439: END IF;
1440:
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: -- Get message count and data
1443: cto_msg_pub.count_and_get
1444: ( p_msg_count => x_msg_count
1445: , p_msg_data => x_msg_data

Line 1474: x_return_status := FND_API.G_RET_STS_SUCCESS;

1470: l_last_idx number;
1471: lStmtNum number;
1472: BEGIN
1473:
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475: IF PG_DEBUG <> 0 THEN
1476: oe_debug_pub.add('Entered populate_parent_ato',5);
1477: END IF;
1478:

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: oe_debug_pub.add('populate_parent_ato: ' || 'Others Exception in stmt num: '
1737: || to_char(lStmtNum), 1);
1738: oe_debug_pub.add('errmsg'||sqlerrm,5);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: -- Get message count and data
1742: cto_msg_pub.count_and_get
1743: ( p_msg_count => x_msg_count
1744: , p_msg_data => x_msg_data

Line 1769: x_return_status := FND_API.G_RET_STS_SUCCESS;

1765: lStmtNum number;
1766:
1767: begin
1768:
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770: IF PG_DEBUG <> 0 THEN
1771: oe_debug_pub.add('Entered populate_plan_level',5);
1772: END IF;
1773:

Line 1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1865: oe_debug_pub.add('populate_plan_level : ' || 'Others Exception in stmt num: '
1866: || to_char(lStmtNum), 1);
1867: oe_debug_pub.add('errmsg'||sqlerrm,5);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: -- Get message count and data
1871: cto_msg_pub.count_and_get
1872: ( p_msg_count => x_msg_count
1873: , p_msg_data => x_msg_data

Line 1933: x_return_status := FND_API.G_RET_STS_SUCCESS;

1929: /*IF PG_DEBUG <> 0 THEN
1930: oe_debug_pub.add('Entered perform_match for =>'|| p_ato_line_id
1931: ||'custm prof=>'||p_custom_match_profile,1);
1932: END IF;*/
1933: x_return_status := FND_API.G_RET_STS_SUCCESS;
1934:
1935: lStmtNum:=10;
1936: for lNextRec in c_model_lines loop
1937:

Line 1995: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1991: IF PG_DEBUG <> 0 THEN
1992: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
1993: END IF; --Bugfix 6452747
1994:
1995: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1996: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1997: raise fnd_api.g_exc_unexpected_error;
1998: end if;
1999:

Line 1997: raise fnd_api.g_exc_unexpected_error;

1993: END IF; --Bugfix 6452747
1994:
1995: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1996: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
1997: raise fnd_api.g_exc_unexpected_error;
1998: end if;
1999:
2000: --check for error cases
2001: if ( l_lock_status <> 0 ) THEN

Line 2005: raise fnd_api.g_exc_unexpected_error;

2001: if ( l_lock_status <> 0 ) THEN
2002: if (l_lock_status = 1) then -- timeout
2003: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
2004: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2005: raise fnd_api.g_exc_unexpected_error;
2006:
2007: elsif (l_lock_status = 2) then -- deadlock
2008: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2009: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');

Line 2010: raise fnd_api.g_exc_unexpected_error;

2006:
2007: elsif (l_lock_status = 2) then -- deadlock
2008: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2009: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2010: raise fnd_api.g_exc_unexpected_error;
2011:
2012: elsif (l_lock_status = 3) then -- parameter error
2013: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2014: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');

Line 2015: raise fnd_api.g_exc_unexpected_error;

2011:
2012: elsif (l_lock_status = 3) then -- parameter error
2013: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2014: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2015: raise fnd_api.g_exc_unexpected_error;
2016:
2017: elsif (l_lock_status = 4) then -- already locked.
2018: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
2019: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');

Line 2025: raise fnd_api.g_exc_unexpected_error;

2021:
2022: else -- internal error - not fault of user
2023: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
2024: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
2025: raise fnd_api.g_exc_unexpected_error;
2026: end if;
2027: else
2028: IF PG_DEBUG <> 0 THEN
2029: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');

Line 2050: raise fnd_api.g_exc_error;

2046:
2047:
2048:
2049: if lStatus <> 1 then
2050: raise fnd_api.g_exc_error;
2051: end if;
2052: ELSIF lPerformMatch = 'C' THEN
2053: IF PG_DEBUG <> 0 THEN
2054: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);

Line 2067: raise fnd_api.g_exc_error;

2063: xTableName => l_x_table_name);
2064:
2065:
2066: if lStatus <> 1 then
2067: raise fnd_api.g_exc_error;
2068: end if;
2069:
2070: END IF;
2071:

Line 2123: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2119: x_Msg_Count => x_Msg_Count,
2120: x_Msg_Data => x_msg_data,
2121: p_hash_value => l_hash_value);
2122:
2123: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2124: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2125: raise fnd_api.g_exc_unexpected_error;
2126: end if;
2127:

Line 2125: raise fnd_api.g_exc_unexpected_error;

2121: p_hash_value => l_hash_value);
2122:
2123: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2124: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2125: raise fnd_api.g_exc_unexpected_error;
2126: end if;
2127:
2128: --
2129: -- end bugfix 4227993

Line 2135: raise fnd_api.g_exc_error;

2131:
2132:
2133: else
2134:
2135: raise fnd_api.g_exc_error;
2136:
2137: end if; -- end lStatus = 1 and lXConfigID is not null
2138:
2139: end if; -- else perform_match = 'U'

Line 2178: WHEN fnd_api.g_exc_error THEN

2174:
2175:
2176:
2177: EXCEPTION
2178: WHEN fnd_api.g_exc_error THEN
2179: IF PG_DEBUG <> 0 THEN
2180: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '
2181: || to_char(lStmtNum), 1);
2182: END IF;

Line 2183: x_return_status := FND_API.G_RET_STS_ERROR;

2179: IF PG_DEBUG <> 0 THEN
2180: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '
2181: || to_char(lStmtNum), 1);
2182: END IF;
2183: x_return_status := FND_API.G_RET_STS_ERROR;
2184: -- Get message count and data
2185: cto_msg_pub.count_and_get
2186: ( p_msg_count => x_msg_count
2187: , p_msg_data => x_msg_data

Line 2189: WHEN fnd_api.g_exc_unexpected_error THEN

2185: cto_msg_pub.count_and_get
2186: ( p_msg_count => x_msg_count
2187: , p_msg_data => x_msg_data
2188: );
2189: WHEN fnd_api.g_exc_unexpected_error THEN
2190: IF PG_DEBUG <> 0 THEN
2191: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '
2192: || to_char(lStmtNum), 1);
2193: END IF;

Line 2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2190: IF PG_DEBUG <> 0 THEN
2191: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '
2192: || to_char(lStmtNum), 1);
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2195: -- Get message count and data
2196: cto_msg_pub.count_and_get
2197: ( p_msg_count => x_msg_count
2198: , p_msg_data => x_msg_data

Line 2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2203: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '
2204: || to_char(lStmtNum), 1);
2205: oe_debug_pub.add('errmsg'||sqlerrm,1);
2206: END IF;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: -- Get message count and data
2209: cto_msg_pub.count_and_get
2210: ( p_msg_count => x_msg_count
2211: , p_msg_data => x_msg_data

Line 2228: x_return_status := FND_API.G_RET_STS_SUCCESS;

2224: l_model_line_id number;
2225: lStmtNum number :=10;
2226: BEGIN
2227:
2228: x_return_status := FND_API.G_RET_STS_SUCCESS;
2229:
2230:
2231: g_reuse_tbl(p_model_line_id).reuse_config := 'N';
2232:

Line 2246: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2242:
2243: flag_reuse_config(p_model_line_id =>l_model_line_id,
2244: x_return_status =>x_return_status
2245: );
2246: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2247: RAISE fnd_api.g_exc_unexpected_error;
2248: END IF;
2249:
2250: END IF;

Line 2247: RAISE fnd_api.g_exc_unexpected_error;

2243: flag_reuse_config(p_model_line_id =>l_model_line_id,
2244: x_return_status =>x_return_status
2245: );
2246: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2247: RAISE fnd_api.g_exc_unexpected_error;
2248: END IF;
2249:
2250: END IF;
2251:

Line 2256: WHEN fnd_api.g_exc_unexpected_error THEN

2252:
2253:
2254:
2255: EXCEPTION
2256: WHEN fnd_api.g_exc_unexpected_error THEN
2257: IF PG_DEBUG <> 0 THEN
2258: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '
2259: || to_char(lStmtNum), 1);
2260: END IF;

Line 2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2257: IF PG_DEBUG <> 0 THEN
2258: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '
2259: || to_char(lStmtNum), 1);
2260: END IF;
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2262: /*-- Get message count and data
2263: cto_msg_pub.count_and_get
2264: ( p_msg_count => x_msg_count
2265: , p_msg_data => x_msg_data

Line 2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2273: || to_char(lStmtNum), 1);
2274: oe_debug_pub.add('error='||sqlerrm,1);
2275:
2276: END IF;
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278:
2279:
2280:
2281:

Line 2370: x_return_status := FND_API.G_RET_STS_SUCCESS;

2366:
2367: IF PG_DEBUG <> 0 THEN
2368: oe_debug_pub.add('ENTERED reuse configuration',5);
2369: END IF;
2370: x_return_status := FND_API.G_RET_STS_SUCCESS;
2371:
2372:
2373:
2374: lStmtNum:=10;

Line 2656: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2652: lStmtNum:= 110;
2653: flag_reuse_config(p_model_line_id =>l_parent_ato_line_tbl(i),
2654: x_return_status =>x_return_status
2655: );
2656: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2657: RAISE fnd_api.g_exc_unexpected_error;
2658: END IF;
2659:
2660: END IF;--re-use = Y

Line 2657: RAISE fnd_api.g_exc_unexpected_error;

2653: flag_reuse_config(p_model_line_id =>l_parent_ato_line_tbl(i),
2654: x_return_status =>x_return_status
2655: );
2656: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2657: RAISE fnd_api.g_exc_unexpected_error;
2658: END IF;
2659:
2660: END IF;--re-use = Y
2661: END LOOP;

Line 2760: WHEN fnd_api.g_exc_error THEN

2756:
2757:
2758: EXCEPTION
2759:
2760: WHEN fnd_api.g_exc_error THEN
2761: IF PG_DEBUG <> 0 THEN
2762: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '
2763: || to_char(lStmtNum), 1);
2764: END IF;

Line 2765: x_return_status := FND_API.G_RET_STS_ERROR;

2761: IF PG_DEBUG <> 0 THEN
2762: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '
2763: || to_char(lStmtNum), 1);
2764: END IF;
2765: x_return_status := FND_API.G_RET_STS_ERROR;
2766: -- Get message count and data
2767: cto_msg_pub.count_and_get
2768: ( p_msg_count => x_msg_count
2769: , p_msg_data => x_msg_data

Line 2771: WHEN fnd_api.g_exc_unexpected_error THEN

2767: cto_msg_pub.count_and_get
2768: ( p_msg_count => x_msg_count
2769: , p_msg_data => x_msg_data
2770: );
2771: WHEN fnd_api.g_exc_unexpected_error THEN
2772: IF PG_DEBUG <> 0 THEN
2773: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '
2774: || to_char(lStmtNum), 1);
2775: END IF;

Line 2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2772: IF PG_DEBUG <> 0 THEN
2773: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '
2774: || to_char(lStmtNum), 1);
2775: END IF;
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2777: -- Get message count and data
2778: cto_msg_pub.count_and_get
2779: ( p_msg_count => x_msg_count
2780: , p_msg_data => x_msg_data

Line 2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2786: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '
2787: || to_char(lStmtNum), 1);
2788: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2789: END IF;
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791: -- Get message count and data
2792: cto_msg_pub.count_and_get
2793: ( p_msg_count => x_msg_count
2794: , p_msg_data => x_msg_data

Line 2829: x_return_status := FND_API.G_RET_STS_SUCCESS;

2825: lStmtNum NUMBER;
2826:
2827: BEGIN
2828:
2829: x_return_status := FND_API.G_RET_STS_SUCCESS;
2830:
2831: lStmtNum:=10;
2832: l_last_index := p_match_rec_of_tab.line_id.count;
2833:

Line 2874: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2870: x_msg_count,
2871: x_msg_data
2872: );
2873:
2874: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2875: oe_debug_pub.add('SUCCESS after xfer_tab_to_rec',5);
2876:
2877: --add retrun status and error mesages to these
2878: lStmtNum:=50;

Line 2886: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2882: x_return_status => x_return_status,
2883: x_msg_count => x_msg_count,
2884: x_msg_data => x_msg_data );
2885:
2886: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2888: || FND_API.G_RET_STS_ERROR,5);

2884: x_msg_data => x_msg_data );
2885:
2886: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);

Line 2889: RAISE fnd_api.g_exc_error;

2885:
2886: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2893: RAISE fnd_api.g_exc_unexpected_error;

Line 2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2886: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2887: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2893: RAISE fnd_api.g_exc_unexpected_error;
2894: END IF;

Line 2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);

2888: || FND_API.G_RET_STS_ERROR,5);
2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2893: RAISE fnd_api.g_exc_unexpected_error;
2894: END IF;
2895:
2896:

Line 2893: RAISE fnd_api.g_exc_unexpected_error;

2889: RAISE fnd_api.g_exc_error;
2890: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2891: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2892: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2893: RAISE fnd_api.g_exc_unexpected_error;
2894: END IF;
2895:
2896:
2897:

Line 2898: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2894: END IF;
2895:
2896:
2897:
2898: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2899: oe_debug_pub.add('SUCCESS after populate_parent_ato=>');
2900: lStmtNum:=60;
2901: populate_plan_level( P_tab_of_rec => l_tab_of_rec,
2902: x_return_status => x_return_status,

Line 2905: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2901: populate_plan_level( P_tab_of_rec => l_tab_of_rec,
2902: x_return_status => x_return_status,
2903: x_msg_count => x_msg_count,
2904: x_msg_data => x_msg_data );
2905: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2906: oe_debug_pub.add('status after after populate_parent_ato=>'
2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2907: || FND_API.G_RET_STS_ERROR);

2903: x_msg_count => x_msg_count,
2904: x_msg_data => x_msg_data );
2905: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2906: oe_debug_pub.add('status after after populate_parent_ato=>'
2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'
2911: || FND_API.G_RET_STS_UNEXP_ERROR );

Line 2908: RAISE fnd_api.g_exc_error;

2904: x_msg_data => x_msg_data );
2905: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2906: oe_debug_pub.add('status after after populate_parent_ato=>'
2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'
2911: || FND_API.G_RET_STS_UNEXP_ERROR );
2912: RAISE fnd_api.g_exc_unexpected_error;

Line 2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2905: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2906: oe_debug_pub.add('status after after populate_parent_ato=>'
2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'
2911: || FND_API.G_RET_STS_UNEXP_ERROR );
2912: RAISE fnd_api.g_exc_unexpected_error;
2913: END IF;

Line 2911: || FND_API.G_RET_STS_UNEXP_ERROR );

2907: || FND_API.G_RET_STS_ERROR);
2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'
2911: || FND_API.G_RET_STS_UNEXP_ERROR );
2912: RAISE fnd_api.g_exc_unexpected_error;
2913: END IF;
2914:
2915:

Line 2912: RAISE fnd_api.g_exc_unexpected_error;

2908: RAISE fnd_api.g_exc_error;
2909: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: oe_debug_pub.add('status after after populate_parent_ato=>'
2911: || FND_API.G_RET_STS_UNEXP_ERROR );
2912: RAISE fnd_api.g_exc_unexpected_error;
2913: END IF;
2914:
2915:
2916:

Line 2917: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2913: END IF;
2914:
2915:
2916:
2917: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2918: oe_debug_pub.add('SUCCESS after populate_plan_level=>');
2919:
2920: lStmtNum:=70;
2921: xfer_rec_to_tab(

Line 2929: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2925: x_msg_count => x_msg_count,
2926: x_msg_data => x_msg_data
2927: );
2928:
2929: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2930: oe_debug_pub.add('status after after populate_plan_level=>'
2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2931: || FND_API.G_RET_STS_ERROR);

2927: );
2928:
2929: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2930: oe_debug_pub.add('status after after populate_plan_level=>'
2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'
2935: || FND_API.G_RET_STS_UNEXP_ERROR );

Line 2932: RAISE fnd_api.g_exc_error;

2928:
2929: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2930: oe_debug_pub.add('status after after populate_plan_level=>'
2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'
2935: || FND_API.G_RET_STS_UNEXP_ERROR );
2936: RAISE fnd_api.g_exc_unexpected_error;

Line 2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2929: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2930: oe_debug_pub.add('status after after populate_plan_level=>'
2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'
2935: || FND_API.G_RET_STS_UNEXP_ERROR );
2936: RAISE fnd_api.g_exc_unexpected_error;
2937: END IF;

Line 2935: || FND_API.G_RET_STS_UNEXP_ERROR );

2931: || FND_API.G_RET_STS_ERROR);
2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'
2935: || FND_API.G_RET_STS_UNEXP_ERROR );
2936: RAISE fnd_api.g_exc_unexpected_error;
2937: END IF;
2938:
2939:

Line 2936: RAISE fnd_api.g_exc_unexpected_error;

2932: RAISE fnd_api.g_exc_error;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: oe_debug_pub.add('status after after populate_plan_level=>'
2935: || FND_API.G_RET_STS_UNEXP_ERROR );
2936: RAISE fnd_api.g_exc_unexpected_error;
2937: END IF;
2938:
2939:
2940: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2940: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2936: RAISE fnd_api.g_exc_unexpected_error;
2937: END IF;
2938:
2939:
2940: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2941: oe_debug_pub.add('SUCCESS after xfer_rec_to_tabl=>');
2942:
2943: lStmtNum:=80;
2944: --update the remaining columns into bcol_temp

Line 2953: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2949: GOP_PARENT_ATO_LINE_ID = p_match_rec_of_tab.GOP_PARENT_ATO_LINE_ID(i),
2950: PLAN_LEVEL = p_match_rec_of_tab.PLAN_LEVEL (i)
2951: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);
2952:
2953: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2955: || FND_API.G_RET_STS_ERROR);

2951: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);
2952:
2953: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2959: || FND_API.G_RET_STS_UNEXP_ERROR );

Line 2956: RAISE fnd_api.g_exc_error;

2952:
2953: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2959: || FND_API.G_RET_STS_UNEXP_ERROR );
2960: RAISE fnd_api.g_exc_unexpected_error;

Line 2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2953: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2954: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2959: || FND_API.G_RET_STS_UNEXP_ERROR );
2960: RAISE fnd_api.g_exc_unexpected_error;
2961: END IF;

Line 2959: || FND_API.G_RET_STS_UNEXP_ERROR );

2955: || FND_API.G_RET_STS_ERROR);
2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2959: || FND_API.G_RET_STS_UNEXP_ERROR );
2960: RAISE fnd_api.g_exc_unexpected_error;
2961: END IF;
2962:
2963:

Line 2960: RAISE fnd_api.g_exc_unexpected_error;

2956: RAISE fnd_api.g_exc_error;
2957: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2959: || FND_API.G_RET_STS_UNEXP_ERROR );
2960: RAISE fnd_api.g_exc_unexpected_error;
2961: END IF;
2962:
2963:
2964: EXCEPTION

Line 2965: WHEN fnd_api.g_exc_error THEN

2961: END IF;
2962:
2963:
2964: EXCEPTION
2965: WHEN fnd_api.g_exc_error THEN
2966: IF PG_DEBUG <> 0 THEN
2967: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '
2968: || to_char(lStmtNum), 1);
2969: END IF;

Line 2970: x_return_status := FND_API.G_RET_STS_ERROR;

2966: IF PG_DEBUG <> 0 THEN
2967: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '
2968: || to_char(lStmtNum), 1);
2969: END IF;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: -- Get message count and data
2972: cto_msg_pub.count_and_get
2973: ( p_msg_count => x_msg_count
2974: , p_msg_data => x_msg_data

Line 2976: WHEN fnd_api.g_exc_unexpected_error THEN

2972: cto_msg_pub.count_and_get
2973: ( p_msg_count => x_msg_count
2974: , p_msg_data => x_msg_data
2975: );
2976: WHEN fnd_api.g_exc_unexpected_error THEN
2977: IF PG_DEBUG <> 0 THEN
2978: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '
2979: || to_char(lStmtNum), 1);
2980: END IF;

Line 2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2977: IF PG_DEBUG <> 0 THEN
2978: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '
2979: || to_char(lStmtNum), 1);
2980: END IF;
2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2982: -- Get message count and data
2983: cto_msg_pub.count_and_get
2984: ( p_msg_count => x_msg_count
2985: , p_msg_data => x_msg_data

Line 2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2989: IF PG_DEBUG <> 0 THEN
2990: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||
2991: to_char(lStmtNum), 1);
2992: END IF;
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2994: -- Get message count and data
2995: cto_msg_pub.count_and_get
2996: ( p_msg_count => x_msg_count
2997: , p_msg_data => x_msg_data

Line 3021: x_return_status := FND_API.G_RET_STS_SUCCESS;

3017: l_last_index number;
3018: lStmtNum number;
3019:
3020: BEGIN
3021: x_return_status := FND_API.G_RET_STS_SUCCESS;
3022:
3023: lStmtNum:=10;
3024: l_last_index := p_match_rec_of_tab.line_id.count;
3025: IF PG_DEBUG <> 0 THEN

Line 3103: WHEN fnd_api.g_exc_error THEN

3099:
3100:
3101:
3102: EXCEPTION
3103: WHEN fnd_api.g_exc_error THEN
3104: IF PG_DEBUG <> 0 THEN
3105: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '
3106: || to_char(lStmtNum), 1);
3107: END IF;

Line 3108: x_return_status := FND_API.G_RET_STS_ERROR;

3104: IF PG_DEBUG <> 0 THEN
3105: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '
3106: || to_char(lStmtNum), 1);
3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: -- Get message count and data
3110: cto_msg_pub.count_and_get
3111: ( p_msg_count => x_msg_count
3112: , p_msg_data => x_msg_data

Line 3114: WHEN fnd_api.g_exc_unexpected_error THEN

3110: cto_msg_pub.count_and_get
3111: ( p_msg_count => x_msg_count
3112: , p_msg_data => x_msg_data
3113: );
3114: WHEN fnd_api.g_exc_unexpected_error THEN
3115: IF PG_DEBUG <> 0 THEN
3116: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '
3117: || to_char(lStmtNum), 1);
3118: END IF;

Line 3119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3115: IF PG_DEBUG <> 0 THEN
3116: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '
3117: || to_char(lStmtNum), 1);
3118: END IF;
3119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3120: -- Get message count and data
3121: cto_msg_pub.count_and_get
3122: ( p_msg_count => x_msg_count
3123: , p_msg_data => x_msg_data

Line 3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3128: oe_debug_pub.add('error='||sqlerrm);
3129: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3130: || to_char(lStmtNum), 1);
3131: END IF;
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133: -- Get message count and data
3134: cto_msg_pub.count_and_get
3135: ( p_msg_count => x_msg_count
3136: , p_msg_data => x_msg_data

Line 3320: WHEN fnd_api.g_exc_error THEN

3316:
3317:
3318:
3319: EXCEPTION
3320: WHEN fnd_api.g_exc_error THEN
3321: IF PG_DEBUG <> 0 THEN
3322: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '
3323: || to_char(lStmtNum), 1);
3324: END IF;

Line 3325: x_return_status := FND_API.G_RET_STS_ERROR;

3321: IF PG_DEBUG <> 0 THEN
3322: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '
3323: || to_char(lStmtNum), 1);
3324: END IF;
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: -- Get message count and data
3327: cto_msg_pub.count_and_get
3328: ( p_msg_count => x_msg_count
3329: , p_msg_data => x_msg_data

Line 3331: WHEN fnd_api.g_exc_unexpected_error THEN

3327: cto_msg_pub.count_and_get
3328: ( p_msg_count => x_msg_count
3329: , p_msg_data => x_msg_data
3330: );
3331: WHEN fnd_api.g_exc_unexpected_error THEN
3332: IF PG_DEBUG <> 0 THEN
3333: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '
3334: || to_char(lStmtNum), 1);
3335: END IF;

Line 3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3332: IF PG_DEBUG <> 0 THEN
3333: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '
3334: || to_char(lStmtNum), 1);
3335: END IF;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3337: -- Get message count and data
3338: cto_msg_pub.count_and_get
3339: ( p_msg_count => x_msg_count
3340: , p_msg_data => x_msg_data

Line 3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3345: oe_debug_pub.add('error='||sqlerrm);
3346: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3347: || to_char(lStmtNum), 1);
3348: END IF;
3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3350: -- Get message count and data
3351: cto_msg_pub.count_and_get
3352: ( p_msg_count => x_msg_count
3353: , p_msg_data => x_msg_data

Line 3397: WHEN fnd_api.g_exc_error THEN

3393:
3394: END LOOP;
3395:
3396: EXCEPTION
3397: WHEN fnd_api.g_exc_error THEN
3398: IF PG_DEBUG <> 0 THEN
3399: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '
3400: || to_char(lStmtNum), 1);
3401: END IF;

Line 3402: x_return_status := FND_API.G_RET_STS_ERROR;

3398: IF PG_DEBUG <> 0 THEN
3399: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '
3400: || to_char(lStmtNum), 1);
3401: END IF;
3402: x_return_status := FND_API.G_RET_STS_ERROR;
3403: -- Get message count and data
3404: cto_msg_pub.count_and_get
3405: ( p_msg_count => x_msg_count
3406: , p_msg_data => x_msg_data

Line 3408: WHEN fnd_api.g_exc_unexpected_error THEN

3404: cto_msg_pub.count_and_get
3405: ( p_msg_count => x_msg_count
3406: , p_msg_data => x_msg_data
3407: );
3408: WHEN fnd_api.g_exc_unexpected_error THEN
3409: IF PG_DEBUG <> 0 THEN
3410: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '
3411: || to_char(lStmtNum), 1);
3412: END IF;

Line 3413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3409: IF PG_DEBUG <> 0 THEN
3410: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '
3411: || to_char(lStmtNum), 1);
3412: END IF;
3413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3414: -- Get message count and data
3415: cto_msg_pub.count_and_get
3416: ( p_msg_count => x_msg_count
3417: , p_msg_data => x_msg_data

Line 3426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3422: oe_debug_pub.add('error='||sqlerrm);
3423: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3424: || to_char(lStmtNum), 1);
3425: END IF;
3426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3427: -- Get message count and data
3428: cto_msg_pub.count_and_get
3429: ( p_msg_count => x_msg_count
3430: , p_msg_data => x_msg_data

Line 3530: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3526:
3527: );
3528:
3529:
3530: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3531: --level1
3532: -- IF PG_DEBUG <> 0 THEN
3533: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||
3534: 'success after Evaluate_N_Pop_Match_Flag', 1);

Line 3537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3533: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||
3534: 'success after Evaluate_N_Pop_Match_Flag', 1);
3535: -- END IF;
3536:
3537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE fnd_api.g_exc_error;
3539: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE fnd_api.g_exc_unexpected_error;
3541: END IF;

Line 3538: RAISE fnd_api.g_exc_error;

3534: 'success after Evaluate_N_Pop_Match_Flag', 1);
3535: -- END IF;
3536:
3537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE fnd_api.g_exc_error;
3539: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE fnd_api.g_exc_unexpected_error;
3541: END IF;
3542:

Line 3539: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3535: -- END IF;
3536:
3537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE fnd_api.g_exc_error;
3539: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE fnd_api.g_exc_unexpected_error;
3541: END IF;
3542:
3543: lStmtNum := 40;

Line 3540: RAISE fnd_api.g_exc_unexpected_error;

3536:
3537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3538: RAISE fnd_api.g_exc_error;
3539: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3540: RAISE fnd_api.g_exc_unexpected_error;
3541: END IF;
3542:
3543: lStmtNum := 40;
3544: CTO_MATCH_CONFIG.xfer_match_flag_to_rec_of_tab

Line 3554: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3550: x_msg_data => X_msg_data
3551: );
3552:
3553:
3554: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3555: --level1
3556: IF PG_DEBUG <> 0 THEN
3557: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3558: END IF;

Line 3560: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3556: IF PG_DEBUG <> 0 THEN
3557: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3558: END IF;
3559:
3560: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3561: RAISE fnd_api.g_exc_error;
3562: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3563: RAISE fnd_api.g_exc_unexpected_error;
3564: END IF;

Line 3561: RAISE fnd_api.g_exc_error;

3557: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3558: END IF;
3559:
3560: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3561: RAISE fnd_api.g_exc_error;
3562: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3563: RAISE fnd_api.g_exc_unexpected_error;
3564: END IF;
3565:

Line 3562: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3558: END IF;
3559:
3560: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3561: RAISE fnd_api.g_exc_error;
3562: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3563: RAISE fnd_api.g_exc_unexpected_error;
3564: END IF;
3565:
3566: lStmtNum := 50;

Line 3563: RAISE fnd_api.g_exc_unexpected_error;

3559:
3560: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3561: RAISE fnd_api.g_exc_error;
3562: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3563: RAISE fnd_api.g_exc_unexpected_error;
3564: END IF;
3565:
3566: lStmtNum := 50;
3567: FORALL i IN 1..l_match_flag_rec_of_tab.line_id.count

Line 3578: WHEN fnd_api.g_exc_error THEN

3574: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'Sql%row count ='||sql%rowcount,3);
3575: END IF;
3576:
3577: EXCEPTION
3578: WHEN fnd_api.g_exc_error THEN
3579: IF PG_DEBUG <> 0 THEN
3580: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '
3581: || to_char(lStmtNum), 1);
3582: END IF;

Line 3583: x_return_status := FND_API.G_RET_STS_ERROR;

3579: IF PG_DEBUG <> 0 THEN
3580: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '
3581: || to_char(lStmtNum), 1);
3582: END IF;
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: -- Get message count and data
3585: cto_msg_pub.count_and_get
3586: ( p_msg_count => x_msg_count
3587: , p_msg_data => x_msg_data

Line 3589: WHEN fnd_api.g_exc_unexpected_error THEN

3585: cto_msg_pub.count_and_get
3586: ( p_msg_count => x_msg_count
3587: , p_msg_data => x_msg_data
3588: );
3589: WHEN fnd_api.g_exc_unexpected_error THEN
3590: IF PG_DEBUG <> 0 THEN
3591: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '
3592: || to_char(lStmtNum), 1);
3593: END IF;

Line 3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3590: IF PG_DEBUG <> 0 THEN
3591: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '
3592: || to_char(lStmtNum), 1);
3593: END IF;
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3595: -- Get message count and data
3596: cto_msg_pub.count_and_get
3597: ( p_msg_count => x_msg_count
3598: , p_msg_data => x_msg_data

Line 3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3604: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '
3605: || to_char(lStmtNum), 1);
3606: oe_debug_pub.add('error '||sqlerrm,1);
3607: END IF;
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3609: -- Get message count and data
3610: cto_msg_pub.count_and_get
3611: ( p_msg_count => x_msg_count
3612: , p_msg_data => x_msg_data