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_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 1963: x_return_status := FND_API.G_RET_STS_SUCCESS;

1959: /*IF PG_DEBUG <> 0 THEN
1960: oe_debug_pub.add('Entered perform_match for =>'|| p_ato_line_id
1961: ||'custm prof=>'||p_custom_match_profile,1);
1962: END IF;*/
1963: x_return_status := FND_API.G_RET_STS_SUCCESS;
1964:
1965: lStmtNum:=10;
1966: for lNextRec in c_model_lines loop
1967:

Line 2030: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2026: IF PG_DEBUG <> 0 THEN
2027: oe_debug_pub.add('Calling cto_utility_pk.lock_for_match: end time: ' || to_char(sysdate , 'MM/DD/YYYY HH24:MI:SS'), 1);
2028: END IF; --Bugfix 6452747
2029:
2030: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2031: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2032: raise fnd_api.g_exc_unexpected_error;
2033: end if;
2034:

Line 2032: raise fnd_api.g_exc_unexpected_error;

2028: END IF; --Bugfix 6452747
2029:
2030: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2031: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2032: raise fnd_api.g_exc_unexpected_error;
2033: end if;
2034:
2035: --check for error cases
2036: if ( l_lock_status <> 0 ) THEN

Line 2040: raise fnd_api.g_exc_unexpected_error;

2036: if ( l_lock_status <> 0 ) THEN
2037: if (l_lock_status = 1) then -- timeout
2038: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
2039: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2040: raise fnd_api.g_exc_unexpected_error;
2041:
2042: elsif (l_lock_status = 2) then -- deadlock
2043: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2044: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');

Line 2045: raise fnd_api.g_exc_unexpected_error;

2041:
2042: elsif (l_lock_status = 2) then -- deadlock
2043: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2044: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2045: raise fnd_api.g_exc_unexpected_error;
2046:
2047: elsif (l_lock_status = 3) then -- parameter error
2048: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2049: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');

Line 2050: raise fnd_api.g_exc_unexpected_error;

2046:
2047: elsif (l_lock_status = 3) then -- parameter error
2048: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2049: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2050: raise fnd_api.g_exc_unexpected_error;
2051:
2052: elsif (l_lock_status = 4) then -- already locked.
2053: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
2054: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');

Line 2060: raise fnd_api.g_exc_unexpected_error;

2056:
2057: else -- internal error - not fault of user
2058: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
2059: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
2060: raise fnd_api.g_exc_unexpected_error;
2061: end if;
2062: else
2063: IF PG_DEBUG <> 0 THEN
2064: oe_debug_pub.add('match_and_create_all_items: ' || 'Successfully obtained lock for match.');

Line 2085: raise fnd_api.g_exc_error;

2081:
2082:
2083:
2084: if lStatus <> 1 then
2085: raise fnd_api.g_exc_error;
2086: end if;
2087: ELSIF lPerformMatch = 'C' THEN
2088: IF PG_DEBUG <> 0 THEN
2089: oe_debug_pub.add('match_and_create_all_items: ' || 'Custom Match.', 1);

Line 2102: raise fnd_api.g_exc_error;

2098: xTableName => l_x_table_name);
2099:
2100:
2101: if lStatus <> 1 then
2102: raise fnd_api.g_exc_error;
2103: end if;
2104:
2105: END IF;
2106:

Line 2158: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2154: x_Msg_Count => x_Msg_Count,
2155: x_Msg_Data => x_msg_data,
2156: p_hash_value => l_hash_value);
2157:
2158: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2159: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2160: raise fnd_api.g_exc_unexpected_error;
2161: end if;
2162:

Line 2160: raise fnd_api.g_exc_unexpected_error;

2156: p_hash_value => l_hash_value);
2157:
2158: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2159: oe_debug_pub.add('match_and_create_all_items: '|| 'get_user_lock returned error');
2160: raise fnd_api.g_exc_unexpected_error;
2161: end if;
2162:
2163: --
2164: -- end bugfix 4227993

Line 2170: raise fnd_api.g_exc_error;

2166:
2167:
2168: else
2169:
2170: raise fnd_api.g_exc_error;
2171:
2172: end if; -- end lStatus = 1 and lXConfigID is not null
2173:
2174: end if; -- else perform_match = 'U'

Line 2213: WHEN fnd_api.g_exc_error THEN

2209:
2210:
2211:
2212: EXCEPTION
2213: WHEN fnd_api.g_exc_error THEN
2214: IF PG_DEBUG <> 0 THEN
2215: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '
2216: || to_char(lStmtNum), 1);
2217: END IF;

Line 2218: x_return_status := FND_API.G_RET_STS_ERROR;

2214: IF PG_DEBUG <> 0 THEN
2215: oe_debug_pub.add('perform_match: ' || 'Exception in stmt num: '
2216: || to_char(lStmtNum), 1);
2217: END IF;
2218: x_return_status := FND_API.G_RET_STS_ERROR;
2219: -- Get message count and data
2220: cto_msg_pub.count_and_get
2221: ( p_msg_count => x_msg_count
2222: , p_msg_data => x_msg_data

Line 2224: WHEN fnd_api.g_exc_unexpected_error THEN

2220: cto_msg_pub.count_and_get
2221: ( p_msg_count => x_msg_count
2222: , p_msg_data => x_msg_data
2223: );
2224: WHEN fnd_api.g_exc_unexpected_error THEN
2225: IF PG_DEBUG <> 0 THEN
2226: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '
2227: || to_char(lStmtNum), 1);
2228: END IF;

Line 2229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2225: IF PG_DEBUG <> 0 THEN
2226: oe_debug_pub.add('perform_match: ' || ' Unexpected Exception in stmt num: '
2227: || to_char(lStmtNum), 1);
2228: END IF;
2229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2230: -- Get message count and data
2231: cto_msg_pub.count_and_get
2232: ( p_msg_count => x_msg_count
2233: , p_msg_data => x_msg_data

Line 2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2238: oe_debug_pub.add('perform_match: ' || 'Others Exception in stmt num: '
2239: || to_char(lStmtNum), 1);
2240: oe_debug_pub.add('errmsg'||sqlerrm,1);
2241: END IF;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: -- Get message count and data
2244: cto_msg_pub.count_and_get
2245: ( p_msg_count => x_msg_count
2246: , p_msg_data => x_msg_data

Line 2263: x_return_status := FND_API.G_RET_STS_SUCCESS;

2259: l_model_line_id number;
2260: lStmtNum number :=10;
2261: BEGIN
2262:
2263: x_return_status := FND_API.G_RET_STS_SUCCESS;
2264:
2265:
2266: g_reuse_tbl(p_model_line_id).reuse_config := 'N';
2267:

Line 2281: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2277:
2278: flag_reuse_config(p_model_line_id =>l_model_line_id,
2279: x_return_status =>x_return_status
2280: );
2281: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2282: RAISE fnd_api.g_exc_unexpected_error;
2283: END IF;
2284:
2285: END IF;

Line 2282: RAISE fnd_api.g_exc_unexpected_error;

2278: flag_reuse_config(p_model_line_id =>l_model_line_id,
2279: x_return_status =>x_return_status
2280: );
2281: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2282: RAISE fnd_api.g_exc_unexpected_error;
2283: END IF;
2284:
2285: END IF;
2286:

Line 2291: WHEN fnd_api.g_exc_unexpected_error THEN

2287:
2288:
2289:
2290: EXCEPTION
2291: WHEN fnd_api.g_exc_unexpected_error THEN
2292: IF PG_DEBUG <> 0 THEN
2293: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '
2294: || to_char(lStmtNum), 1);
2295: END IF;

Line 2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2292: IF PG_DEBUG <> 0 THEN
2293: oe_debug_pub.add('flag_reuse_config: ' || ' Unexpected Exception in stmt num: '
2294: || to_char(lStmtNum), 1);
2295: END IF;
2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2297: /*-- Get message count and data
2298: cto_msg_pub.count_and_get
2299: ( p_msg_count => x_msg_count
2300: , p_msg_data => x_msg_data

Line 2312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2308: || to_char(lStmtNum), 1);
2309: oe_debug_pub.add('error='||sqlerrm,1);
2310:
2311: END IF;
2312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2313:
2314:
2315:
2316:

Line 2405: x_return_status := FND_API.G_RET_STS_SUCCESS;

2401:
2402: IF PG_DEBUG <> 0 THEN
2403: oe_debug_pub.add('ENTERED reuse configuration',5);
2404: END IF;
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406:
2407:
2408:
2409: lStmtNum:=10;

Line 2691: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2687: lStmtNum:= 110;
2688: flag_reuse_config(p_model_line_id =>l_parent_ato_line_tbl(i),
2689: x_return_status =>x_return_status
2690: );
2691: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: RAISE fnd_api.g_exc_unexpected_error;
2693: END IF;
2694:
2695: END IF;--re-use = Y

Line 2692: RAISE fnd_api.g_exc_unexpected_error;

2688: flag_reuse_config(p_model_line_id =>l_parent_ato_line_tbl(i),
2689: x_return_status =>x_return_status
2690: );
2691: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: RAISE fnd_api.g_exc_unexpected_error;
2693: END IF;
2694:
2695: END IF;--re-use = Y
2696: END LOOP;

Line 2795: WHEN fnd_api.g_exc_error THEN

2791:
2792:
2793: EXCEPTION
2794:
2795: WHEN fnd_api.g_exc_error THEN
2796: IF PG_DEBUG <> 0 THEN
2797: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '
2798: || to_char(lStmtNum), 1);
2799: END IF;

Line 2800: x_return_status := FND_API.G_RET_STS_ERROR;

2796: IF PG_DEBUG <> 0 THEN
2797: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Exception in stmt num: '
2798: || to_char(lStmtNum), 1);
2799: END IF;
2800: x_return_status := FND_API.G_RET_STS_ERROR;
2801: -- Get message count and data
2802: cto_msg_pub.count_and_get
2803: ( p_msg_count => x_msg_count
2804: , p_msg_data => x_msg_data

Line 2806: WHEN fnd_api.g_exc_unexpected_error THEN

2802: cto_msg_pub.count_and_get
2803: ( p_msg_count => x_msg_count
2804: , p_msg_data => x_msg_data
2805: );
2806: WHEN fnd_api.g_exc_unexpected_error THEN
2807: IF PG_DEBUG <> 0 THEN
2808: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '
2809: || to_char(lStmtNum), 1);
2810: END IF;

Line 2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2807: IF PG_DEBUG <> 0 THEN
2808: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || ' Unexpected Exception in stmt num: '
2809: || to_char(lStmtNum), 1);
2810: END IF;
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2812: -- Get message count and data
2813: cto_msg_pub.count_and_get
2814: ( p_msg_count => x_msg_count
2815: , p_msg_data => x_msg_data

Line 2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2821: oe_debug_pub.add('CTO_REUSE_CONFIGURATION: ' || 'Others Exception in stmt num: '
2822: || to_char(lStmtNum), 1);
2823: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2824: END IF;
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826: -- Get message count and data
2827: cto_msg_pub.count_and_get
2828: ( p_msg_count => x_msg_count
2829: , p_msg_data => x_msg_data

Line 2864: x_return_status := FND_API.G_RET_STS_SUCCESS;

2860: lStmtNum NUMBER;
2861:
2862: BEGIN
2863:
2864: x_return_status := FND_API.G_RET_STS_SUCCESS;
2865:
2866: lStmtNum:=10;
2867: l_last_index := p_match_rec_of_tab.line_id.count;
2868:

Line 2909: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2905: x_msg_count,
2906: x_msg_data
2907: );
2908:
2909: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2910: oe_debug_pub.add('SUCCESS after xfer_tab_to_rec',5);
2911:
2912: --add retrun status and error mesages to these
2913: lStmtNum:=50;

Line 2921: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2917: x_return_status => x_return_status,
2918: x_msg_count => x_msg_count,
2919: x_msg_data => x_msg_data );
2920:
2921: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2922: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2919: x_msg_data => x_msg_data );
2920:
2921: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2922: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2927: || FND_API.G_RET_STS_UNEXP_ERROR,5);

Line 2924: RAISE fnd_api.g_exc_error;

2920:
2921: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2922: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2927: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2928: RAISE fnd_api.g_exc_unexpected_error;

Line 2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2921: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2922: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2927: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2928: RAISE fnd_api.g_exc_unexpected_error;
2929: END IF;

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

2923: || FND_API.G_RET_STS_ERROR,5);
2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2927: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2928: RAISE fnd_api.g_exc_unexpected_error;
2929: END IF;
2930:
2931:

Line 2928: RAISE fnd_api.g_exc_unexpected_error;

2924: RAISE fnd_api.g_exc_error;
2925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: oe_debug_pub.add('status after after xfer_tab_to_rec=>'
2927: || FND_API.G_RET_STS_UNEXP_ERROR,5);
2928: RAISE fnd_api.g_exc_unexpected_error;
2929: END IF;
2930:
2931:
2932:

Line 2933: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2929: END IF;
2930:
2931:
2932:
2933: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2934: oe_debug_pub.add('SUCCESS after populate_parent_ato=>');
2935: lStmtNum:=60;
2936: populate_plan_level( P_tab_of_rec => l_tab_of_rec,
2937: x_return_status => x_return_status,

Line 2940: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2936: populate_plan_level( P_tab_of_rec => l_tab_of_rec,
2937: x_return_status => x_return_status,
2938: x_msg_count => x_msg_count,
2939: x_msg_data => x_msg_data );
2940: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2941: oe_debug_pub.add('status after after populate_parent_ato=>'
2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2942: || FND_API.G_RET_STS_ERROR);

2938: x_msg_count => x_msg_count,
2939: x_msg_data => x_msg_data );
2940: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2941: oe_debug_pub.add('status after after populate_parent_ato=>'
2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'
2946: || FND_API.G_RET_STS_UNEXP_ERROR );

Line 2943: RAISE fnd_api.g_exc_error;

2939: x_msg_data => x_msg_data );
2940: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2941: oe_debug_pub.add('status after after populate_parent_ato=>'
2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'
2946: || FND_API.G_RET_STS_UNEXP_ERROR );
2947: RAISE fnd_api.g_exc_unexpected_error;

Line 2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2940: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2941: oe_debug_pub.add('status after after populate_parent_ato=>'
2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'
2946: || FND_API.G_RET_STS_UNEXP_ERROR );
2947: RAISE fnd_api.g_exc_unexpected_error;
2948: END IF;

Line 2946: || FND_API.G_RET_STS_UNEXP_ERROR );

2942: || FND_API.G_RET_STS_ERROR);
2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'
2946: || FND_API.G_RET_STS_UNEXP_ERROR );
2947: RAISE fnd_api.g_exc_unexpected_error;
2948: END IF;
2949:
2950:

Line 2947: RAISE fnd_api.g_exc_unexpected_error;

2943: RAISE fnd_api.g_exc_error;
2944: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2945: oe_debug_pub.add('status after after populate_parent_ato=>'
2946: || FND_API.G_RET_STS_UNEXP_ERROR );
2947: RAISE fnd_api.g_exc_unexpected_error;
2948: END IF;
2949:
2950:
2951:

Line 2952: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2948: END IF;
2949:
2950:
2951:
2952: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2953: oe_debug_pub.add('SUCCESS after populate_plan_level=>');
2954:
2955: lStmtNum:=70;
2956: xfer_rec_to_tab(

Line 2964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2960: x_msg_count => x_msg_count,
2961: x_msg_data => x_msg_data
2962: );
2963:
2964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2965: oe_debug_pub.add('status after after populate_plan_level=>'
2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2966: || FND_API.G_RET_STS_ERROR);

2962: );
2963:
2964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2965: oe_debug_pub.add('status after after populate_plan_level=>'
2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'
2970: || FND_API.G_RET_STS_UNEXP_ERROR );

Line 2967: RAISE fnd_api.g_exc_error;

2963:
2964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2965: oe_debug_pub.add('status after after populate_plan_level=>'
2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'
2970: || FND_API.G_RET_STS_UNEXP_ERROR );
2971: RAISE fnd_api.g_exc_unexpected_error;

Line 2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2964: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2965: oe_debug_pub.add('status after after populate_plan_level=>'
2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'
2970: || FND_API.G_RET_STS_UNEXP_ERROR );
2971: RAISE fnd_api.g_exc_unexpected_error;
2972: END IF;

Line 2970: || FND_API.G_RET_STS_UNEXP_ERROR );

2966: || FND_API.G_RET_STS_ERROR);
2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'
2970: || FND_API.G_RET_STS_UNEXP_ERROR );
2971: RAISE fnd_api.g_exc_unexpected_error;
2972: END IF;
2973:
2974:

Line 2971: RAISE fnd_api.g_exc_unexpected_error;

2967: RAISE fnd_api.g_exc_error;
2968: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2969: oe_debug_pub.add('status after after populate_plan_level=>'
2970: || FND_API.G_RET_STS_UNEXP_ERROR );
2971: RAISE fnd_api.g_exc_unexpected_error;
2972: END IF;
2973:
2974:
2975: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2975: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2971: RAISE fnd_api.g_exc_unexpected_error;
2972: END IF;
2973:
2974:
2975: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2976: oe_debug_pub.add('SUCCESS after xfer_rec_to_tabl=>');
2977:
2978: lStmtNum:=80;
2979: --update the remaining columns into bcol_temp

Line 2988: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2984: GOP_PARENT_ATO_LINE_ID = p_match_rec_of_tab.GOP_PARENT_ATO_LINE_ID(i),
2985: PLAN_LEVEL = p_match_rec_of_tab.PLAN_LEVEL (i)
2986: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);
2987:
2988: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2989: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2990: || FND_API.G_RET_STS_ERROR);

2986: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);
2987:
2988: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2989: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2994: || FND_API.G_RET_STS_UNEXP_ERROR );

Line 2991: RAISE fnd_api.g_exc_error;

2987:
2988: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2989: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2994: || FND_API.G_RET_STS_UNEXP_ERROR );
2995: RAISE fnd_api.g_exc_unexpected_error;

Line 2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2988: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2989: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2994: || FND_API.G_RET_STS_UNEXP_ERROR );
2995: RAISE fnd_api.g_exc_unexpected_error;
2996: END IF;

Line 2994: || FND_API.G_RET_STS_UNEXP_ERROR );

2990: || FND_API.G_RET_STS_ERROR);
2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2994: || FND_API.G_RET_STS_UNEXP_ERROR );
2995: RAISE fnd_api.g_exc_unexpected_error;
2996: END IF;
2997:
2998:

Line 2995: RAISE fnd_api.g_exc_unexpected_error;

2991: RAISE fnd_api.g_exc_error;
2992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: oe_debug_pub.add('status after after xfer_rec_to_tab=>'
2994: || FND_API.G_RET_STS_UNEXP_ERROR );
2995: RAISE fnd_api.g_exc_unexpected_error;
2996: END IF;
2997:
2998:
2999: EXCEPTION

Line 3000: WHEN fnd_api.g_exc_error THEN

2996: END IF;
2997:
2998:
2999: EXCEPTION
3000: WHEN fnd_api.g_exc_error THEN
3001: IF PG_DEBUG <> 0 THEN
3002: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '
3003: || to_char(lStmtNum), 1);
3004: END IF;

Line 3005: x_return_status := FND_API.G_RET_STS_ERROR;

3001: IF PG_DEBUG <> 0 THEN
3002: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Exception in stmt num: '
3003: || to_char(lStmtNum), 1);
3004: END IF;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: -- Get message count and data
3007: cto_msg_pub.count_and_get
3008: ( p_msg_count => x_msg_count
3009: , p_msg_data => x_msg_data

Line 3011: WHEN fnd_api.g_exc_unexpected_error THEN

3007: cto_msg_pub.count_and_get
3008: ( p_msg_count => x_msg_count
3009: , p_msg_data => x_msg_data
3010: );
3011: WHEN fnd_api.g_exc_unexpected_error THEN
3012: IF PG_DEBUG <> 0 THEN
3013: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '
3014: || to_char(lStmtNum), 1);
3015: END IF;

Line 3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3012: IF PG_DEBUG <> 0 THEN
3013: oe_debug_pub.add(' prepare_bcol_temp_data: ' || ' Unexpected Exception in stmt num: '
3014: || to_char(lStmtNum), 1);
3015: END IF;
3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3017: -- Get message count and data
3018: cto_msg_pub.count_and_get
3019: ( p_msg_count => x_msg_count
3020: , p_msg_data => x_msg_data

Line 3028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3024: IF PG_DEBUG <> 0 THEN
3025: oe_debug_pub.add(' prepare_bcol_temp_data: ' || 'Others Exception in stmt num: ' ||
3026: to_char(lStmtNum), 1);
3027: END IF;
3028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3029: -- Get message count and data
3030: cto_msg_pub.count_and_get
3031: ( p_msg_count => x_msg_count
3032: , p_msg_data => x_msg_data

Line 3056: x_return_status := FND_API.G_RET_STS_SUCCESS;

3052: l_last_index number;
3053: lStmtNum number;
3054:
3055: BEGIN
3056: x_return_status := FND_API.G_RET_STS_SUCCESS;
3057:
3058: lStmtNum:=10;
3059: l_last_index := p_match_rec_of_tab.line_id.count;
3060: IF PG_DEBUG <> 0 THEN

Line 3138: WHEN fnd_api.g_exc_error THEN

3134:
3135:
3136:
3137: EXCEPTION
3138: WHEN fnd_api.g_exc_error THEN
3139: IF PG_DEBUG <> 0 THEN
3140: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '
3141: || to_char(lStmtNum), 1);
3142: END IF;

Line 3143: x_return_status := FND_API.G_RET_STS_ERROR;

3139: IF PG_DEBUG <> 0 THEN
3140: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Exception in stmt num: '
3141: || to_char(lStmtNum), 1);
3142: END IF;
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: -- Get message count and data
3145: cto_msg_pub.count_and_get
3146: ( p_msg_count => x_msg_count
3147: , p_msg_data => x_msg_data

Line 3149: WHEN fnd_api.g_exc_unexpected_error THEN

3145: cto_msg_pub.count_and_get
3146: ( p_msg_count => x_msg_count
3147: , p_msg_data => x_msg_data
3148: );
3149: WHEN fnd_api.g_exc_unexpected_error THEN
3150: IF PG_DEBUG <> 0 THEN
3151: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '
3152: || to_char(lStmtNum), 1);
3153: END IF;

Line 3154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3150: IF PG_DEBUG <> 0 THEN
3151: oe_debug_pub.add('Insert_into_bcol_gt: ' || ' Unexpected Exception in stmt num: '
3152: || to_char(lStmtNum), 1);
3153: END IF;
3154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3155: -- Get message count and data
3156: cto_msg_pub.count_and_get
3157: ( p_msg_count => x_msg_count
3158: , p_msg_data => x_msg_data

Line 3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3163: oe_debug_pub.add('error='||sqlerrm);
3164: oe_debug_pub.add('Insert_into_bcol_gt: ' || 'Others Exception in stmt num: '
3165: || to_char(lStmtNum), 1);
3166: END IF;
3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3168: -- Get message count and data
3169: cto_msg_pub.count_and_get
3170: ( p_msg_count => x_msg_count
3171: , p_msg_data => x_msg_data

Line 3355: WHEN fnd_api.g_exc_error THEN

3351:
3352:
3353:
3354: EXCEPTION
3355: WHEN fnd_api.g_exc_error THEN
3356: IF PG_DEBUG <> 0 THEN
3357: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '
3358: || to_char(lStmtNum), 1);
3359: END IF;

Line 3360: x_return_status := FND_API.G_RET_STS_ERROR;

3356: IF PG_DEBUG <> 0 THEN
3357: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Exception in stmt num: '
3358: || to_char(lStmtNum), 1);
3359: END IF;
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: -- Get message count and data
3362: cto_msg_pub.count_and_get
3363: ( p_msg_count => x_msg_count
3364: , p_msg_data => x_msg_data

Line 3366: WHEN fnd_api.g_exc_unexpected_error THEN

3362: cto_msg_pub.count_and_get
3363: ( p_msg_count => x_msg_count
3364: , p_msg_data => x_msg_data
3365: );
3366: WHEN fnd_api.g_exc_unexpected_error THEN
3367: IF PG_DEBUG <> 0 THEN
3368: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '
3369: || to_char(lStmtNum), 1);
3370: END IF;

Line 3371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3367: IF PG_DEBUG <> 0 THEN
3368: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || ' Unexpected Exception in stmt num: '
3369: || to_char(lStmtNum), 1);
3370: END IF;
3371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3372: -- Get message count and data
3373: cto_msg_pub.count_and_get
3374: ( p_msg_count => x_msg_count
3375: , p_msg_data => x_msg_data

Line 3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3380: oe_debug_pub.add('error='||sqlerrm);
3381: oe_debug_pub.add('Evaluate_N_Pop_Match_Flag: ' || 'Others Exception in stmt num: '
3382: || to_char(lStmtNum), 1);
3383: END IF;
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385: -- Get message count and data
3386: cto_msg_pub.count_and_get
3387: ( p_msg_count => x_msg_count
3388: , p_msg_data => x_msg_data

Line 3432: WHEN fnd_api.g_exc_error THEN

3428:
3429: END LOOP;
3430:
3431: EXCEPTION
3432: WHEN fnd_api.g_exc_error THEN
3433: IF PG_DEBUG <> 0 THEN
3434: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '
3435: || to_char(lStmtNum), 1);
3436: END IF;

Line 3437: x_return_status := FND_API.G_RET_STS_ERROR;

3433: IF PG_DEBUG <> 0 THEN
3434: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Exception in stmt num: '
3435: || to_char(lStmtNum), 1);
3436: END IF;
3437: x_return_status := FND_API.G_RET_STS_ERROR;
3438: -- Get message count and data
3439: cto_msg_pub.count_and_get
3440: ( p_msg_count => x_msg_count
3441: , p_msg_data => x_msg_data

Line 3443: WHEN fnd_api.g_exc_unexpected_error THEN

3439: cto_msg_pub.count_and_get
3440: ( p_msg_count => x_msg_count
3441: , p_msg_data => x_msg_data
3442: );
3443: WHEN fnd_api.g_exc_unexpected_error THEN
3444: IF PG_DEBUG <> 0 THEN
3445: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '
3446: || to_char(lStmtNum), 1);
3447: END IF;

Line 3448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3444: IF PG_DEBUG <> 0 THEN
3445: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || ' Unexpected Exception in stmt num: '
3446: || to_char(lStmtNum), 1);
3447: END IF;
3448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3449: -- Get message count and data
3450: cto_msg_pub.count_and_get
3451: ( p_msg_count => x_msg_count
3452: , p_msg_data => x_msg_data

Line 3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3457: oe_debug_pub.add('error='||sqlerrm);
3458: oe_debug_pub.add('xfer_match_flag_to_rec_of_tab: ' || 'Others Exception in stmt num: '
3459: || to_char(lStmtNum), 1);
3460: END IF;
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3462: -- Get message count and data
3463: cto_msg_pub.count_and_get
3464: ( p_msg_count => x_msg_count
3465: , p_msg_data => x_msg_data

Line 3565: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3561:
3562: );
3563:
3564:
3565: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3566: --level1
3567: -- IF PG_DEBUG <> 0 THEN
3568: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||
3569: 'success after Evaluate_N_Pop_Match_Flag', 1);

Line 3572: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3568: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||
3569: 'success after Evaluate_N_Pop_Match_Flag', 1);
3570: -- END IF;
3571:
3572: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3573: RAISE fnd_api.g_exc_error;
3574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;

Line 3573: RAISE fnd_api.g_exc_error;

3569: 'success after Evaluate_N_Pop_Match_Flag', 1);
3570: -- END IF;
3571:
3572: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3573: RAISE fnd_api.g_exc_error;
3574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;
3577:

Line 3574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3570: -- END IF;
3571:
3572: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3573: RAISE fnd_api.g_exc_error;
3574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;
3577:
3578: lStmtNum := 40;

Line 3575: RAISE fnd_api.g_exc_unexpected_error;

3571:
3572: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3573: RAISE fnd_api.g_exc_error;
3574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;
3577:
3578: lStmtNum := 40;
3579: CTO_MATCH_CONFIG.xfer_match_flag_to_rec_of_tab

Line 3589: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3585: x_msg_data => X_msg_data
3586: );
3587:
3588:
3589: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3590: --level1
3591: IF PG_DEBUG <> 0 THEN
3592: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3593: END IF;

Line 3595: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3591: IF PG_DEBUG <> 0 THEN
3592: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3593: END IF;
3594:
3595: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3596: RAISE fnd_api.g_exc_error;
3597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3598: RAISE fnd_api.g_exc_unexpected_error;
3599: END IF;

Line 3596: RAISE fnd_api.g_exc_error;

3592: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'success after xfer_match_flag_to_rec_of_tab', 1);
3593: END IF;
3594:
3595: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3596: RAISE fnd_api.g_exc_error;
3597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3598: RAISE fnd_api.g_exc_unexpected_error;
3599: END IF;
3600:

Line 3597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3593: END IF;
3594:
3595: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3596: RAISE fnd_api.g_exc_error;
3597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3598: RAISE fnd_api.g_exc_unexpected_error;
3599: END IF;
3600:
3601: lStmtNum := 50;

Line 3598: RAISE fnd_api.g_exc_unexpected_error;

3594:
3595: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3596: RAISE fnd_api.g_exc_error;
3597: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3598: RAISE fnd_api.g_exc_unexpected_error;
3599: END IF;
3600:
3601: lStmtNum := 50;
3602: FORALL i IN 1..l_match_flag_rec_of_tab.line_id.count

Line 3613: WHEN fnd_api.g_exc_error THEN

3609: oe_debug_pub.add('Update_BCOLGT_with_match_flag:'||'Sql%row count ='||sql%rowcount,3);
3610: END IF;
3611:
3612: EXCEPTION
3613: WHEN fnd_api.g_exc_error THEN
3614: IF PG_DEBUG <> 0 THEN
3615: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '
3616: || to_char(lStmtNum), 1);
3617: END IF;

Line 3618: x_return_status := FND_API.G_RET_STS_ERROR;

3614: IF PG_DEBUG <> 0 THEN
3615: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || 'Exception in stmt num: '
3616: || to_char(lStmtNum), 1);
3617: END IF;
3618: x_return_status := FND_API.G_RET_STS_ERROR;
3619: -- Get message count and data
3620: cto_msg_pub.count_and_get
3621: ( p_msg_count => x_msg_count
3622: , p_msg_data => x_msg_data

Line 3624: WHEN fnd_api.g_exc_unexpected_error THEN

3620: cto_msg_pub.count_and_get
3621: ( p_msg_count => x_msg_count
3622: , p_msg_data => x_msg_data
3623: );
3624: WHEN fnd_api.g_exc_unexpected_error THEN
3625: IF PG_DEBUG <> 0 THEN
3626: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '
3627: || to_char(lStmtNum), 1);
3628: END IF;

Line 3629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3625: IF PG_DEBUG <> 0 THEN
3626: oe_debug_pub.add('Update_BCOLGT_with_match_flag ' || ' Unexpected Exception in stmt num: '
3627: || to_char(lStmtNum), 1);
3628: END IF;
3629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3630: -- Get message count and data
3631: cto_msg_pub.count_and_get
3632: ( p_msg_count => x_msg_count
3633: , p_msg_data => x_msg_data

Line 3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3639: oe_debug_pub.add('Update_BCOLGT_with_match_flag' || 'Others Exception in stmt num: '
3640: || to_char(lStmtNum), 1);
3641: oe_debug_pub.add('error '||sqlerrm,1);
3642: END IF;
3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3644: -- Get message count and data
3645: cto_msg_pub.count_and_get
3646: ( p_msg_count => x_msg_count
3647: , p_msg_data => x_msg_data