228: RAISE;
229:
230: WHEN OTHERS THEN
231:
232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: OE_MSG_PUB.Add_Exc_Msg
235: ( G_PKG_NAME
236: , 'Pte'
230: WHEN OTHERS THEN
231:
232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: OE_MSG_PUB.Add_Exc_Msg
235: ( G_PKG_NAME
236: , 'Pte'
237: );
238: END IF;
494: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: l_RQT_tbl(I) := l_RQT_rec;
496: l_old_RQT_tbl(I) := l_old_RQT_rec;
497:
498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: OE_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME
502: , 'Rqts'
496: l_old_RQT_tbl(I) := l_old_RQT_rec;
497:
498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: OE_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME
502: , 'Rqts'
503: );
504: END IF;
525: RAISE;
526:
527: WHEN OTHERS THEN
528:
529: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: OE_MSG_PUB.Add_Exc_Msg
532: ( G_PKG_NAME
533: , 'Rqts'
527: WHEN OTHERS THEN
528:
529: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: OE_MSG_PUB.Add_Exc_Msg
532: ( G_PKG_NAME
533: , 'Rqts'
534: );
535: END IF;
787: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788: l_SSC_tbl(I) := l_SSC_rec;
789: l_old_SSC_tbl(I) := l_old_SSC_rec;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
792: THEN
793: OE_MSG_PUB.Add_Exc_Msg
794: ( G_PKG_NAME
795: , 'Sscs'
789: l_old_SSC_tbl(I) := l_old_SSC_rec;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
792: THEN
793: OE_MSG_PUB.Add_Exc_Msg
794: ( G_PKG_NAME
795: , 'Sscs'
796: );
797: END IF;
818: RAISE;
819:
820: WHEN OTHERS THEN
821:
822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
823: THEN
824: OE_MSG_PUB.Add_Exc_Msg
825: ( G_PKG_NAME
826: , 'Sscs'
820: WHEN OTHERS THEN
821:
822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
823: THEN
824: OE_MSG_PUB.Add_Exc_Msg
825: ( G_PKG_NAME
826: , 'Sscs'
827: );
828: END IF;
1080: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: l_PSG_tbl(I) := l_PSG_rec;
1082: l_old_PSG_tbl(I) := l_old_PSG_rec;
1083:
1084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: OE_MSG_PUB.Add_Exc_Msg
1087: ( G_PKG_NAME
1088: , 'Psgs'
1082: l_old_PSG_tbl(I) := l_old_PSG_rec;
1083:
1084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1085: THEN
1086: OE_MSG_PUB.Add_Exc_Msg
1087: ( G_PKG_NAME
1088: , 'Psgs'
1089: );
1090: END IF;
1111: RAISE;
1112:
1113: WHEN OTHERS THEN
1114:
1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1116: THEN
1117: OE_MSG_PUB.Add_Exc_Msg
1118: ( G_PKG_NAME
1119: , 'Psgs'
1113: WHEN OTHERS THEN
1114:
1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1116: THEN
1117: OE_MSG_PUB.Add_Exc_Msg
1118: ( G_PKG_NAME
1119: , 'Psgs'
1120: );
1121: END IF;
1374: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: l_SOU_tbl(I) := l_SOU_rec;
1376: l_old_SOU_tbl(I) := l_old_SOU_rec;
1377:
1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: OE_MSG_PUB.Add_Exc_Msg
1381: ( G_PKG_NAME
1382: , 'Sous'
1376: l_old_SOU_tbl(I) := l_old_SOU_rec;
1377:
1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: OE_MSG_PUB.Add_Exc_Msg
1381: ( G_PKG_NAME
1382: , 'Sous'
1383: );
1384: END IF;
1405: RAISE;
1406:
1407: WHEN OTHERS THEN
1408:
1409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1410: THEN
1411: OE_MSG_PUB.Add_Exc_Msg
1412: ( G_PKG_NAME
1413: , 'Sous'
1407: WHEN OTHERS THEN
1408:
1409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1410: THEN
1411: OE_MSG_PUB.Add_Exc_Msg
1412: ( G_PKG_NAME
1413: , 'Sous'
1414: );
1415: END IF;
1682: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683: l_FNA_tbl(I) := l_FNA_rec;
1684: l_old_FNA_tbl(I) := l_old_FNA_rec;
1685:
1686: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1687: THEN
1688: OE_MSG_PUB.Add_Exc_Msg
1689: ( G_PKG_NAME
1690: , 'Fnas'
1684: l_old_FNA_tbl(I) := l_old_FNA_rec;
1685:
1686: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1687: THEN
1688: OE_MSG_PUB.Add_Exc_Msg
1689: ( G_PKG_NAME
1690: , 'Fnas'
1691: );
1692: END IF;
1727: RAISE;
1728:
1729: WHEN OTHERS THEN
1730:
1731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1732: THEN
1733: OE_MSG_PUB.Add_Exc_Msg
1734: ( G_PKG_NAME
1735: , 'Fnas'
1729: WHEN OTHERS THEN
1730:
1731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1732: THEN
1733: OE_MSG_PUB.Add_Exc_Msg
1734: ( G_PKG_NAME
1735: , 'Fnas'
1736: );
1737: END IF;
1861:
1862: -- Initialize message list.
1863:
1864: IF FND_API.to_Boolean(p_init_msg_list) THEN
1865: OE_MSG_PUB.initialize;
1866: END IF;
1867:
1868: -- Init local table variables.
1869:
2076:
2077: ELSE
2078: --dbms_output.put_line('in qp_qttr_mapping_pvt 22 else ............................');
2079:
2080: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2081: THEN
2082: --dbms_output.put_line('in qp_qttr_mapping_pvt 23 ............................');
2083:
2084: FND_MESSAGE.SET_NAME('QP','QP_API_INV_PARENT_INDEX');
2084: FND_MESSAGE.SET_NAME('QP','QP_API_INV_PARENT_INDEX');
2085: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','SOU');
2086: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
2087: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_SOU_rec.PSG_index);
2088: OE_MSG_PUB.Add;
2089:
2090: END IF;
2091: END IF;
2092: */
2243: END LOOP;
2244:
2245: -- Get message count and data
2246:
2247: OE_MSG_PUB.Count_And_Get
2248: ( p_count => x_msg_count
2249: , p_data => x_msg_data
2250: );
2251:
2262: end if;
2263:
2264: -- Get message count and data
2265:
2266: OE_MSG_PUB.Count_And_Get
2267: ( p_count => x_msg_count
2268: , p_data => x_msg_data
2269: );
2270:
2278: end if;
2279:
2280: -- Get message count and data
2281:
2282: OE_MSG_PUB.Count_And_Get
2283: ( p_count => x_msg_count
2284: , p_data => x_msg_data
2285: );
2286:
2292: qp_delayed_requests_pvt.Clear_Request
2293: (x_return_status => l_return_status);
2294: end if;
2295:
2296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2297: THEN
2298: OE_MSG_PUB.Add_Exc_Msg
2299: ( G_PKG_NAME
2300: , 'Process_Attr_Mapping'
2294: end if;
2295:
2296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2297: THEN
2298: OE_MSG_PUB.Add_Exc_Msg
2299: ( G_PKG_NAME
2300: , 'Process_Attr_Mapping'
2301: );
2302: END IF;
2302: END IF;
2303:
2304: -- Get message count and data
2305:
2306: OE_MSG_PUB.Count_And_Get
2307: ( p_count => x_msg_count
2308: , p_data => x_msg_data
2309: );
2310:
2376:
2377: -- Initialize message list.
2378:
2379: IF FND_API.to_Boolean(p_init_msg_list) THEN
2380: OE_MSG_PUB.initialize;
2381: END IF;
2382:
2383: -- Set Savepoint
2384:
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529:
2530: -- Get message count and data
2531:
2532: OE_MSG_PUB.Count_And_Get
2533: ( p_count => x_msg_count
2534: , p_data => x_msg_data
2535: );
2536:
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543:
2544: -- Get message count and data
2545:
2546: OE_MSG_PUB.Count_And_Get
2547: ( p_count => x_msg_count
2548: , p_data => x_msg_data
2549: );
2550:
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: -- Get message count and data
2560:
2561: OE_MSG_PUB.Count_And_Get
2562: ( p_count => x_msg_count
2563: , p_data => x_msg_data
2564: );
2565:
2570: WHEN OTHERS THEN
2571:
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2573:
2574: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2575: THEN
2576: OE_MSG_PUB.Add_Exc_Msg
2577: ( G_PKG_NAME
2578: , 'Lock_Attr_Mapping'
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2573:
2574: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2575: THEN
2576: OE_MSG_PUB.Add_Exc_Msg
2577: ( G_PKG_NAME
2578: , 'Lock_Attr_Mapping'
2579: );
2580: END IF;
2580: END IF;
2581:
2582: -- Get message count and data
2583:
2584: OE_MSG_PUB.Count_And_Get
2585: ( p_count => x_msg_count
2586: , p_data => x_msg_data
2587: );
2588:
2649:
2650: -- Initialize message list.
2651:
2652: IF FND_API.to_Boolean(p_init_msg_list) THEN
2653: OE_MSG_PUB.initialize;
2654: END IF;
2655:
2656: -- Get PTE ( parent = PTE )
2657:
2733: x_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: -- Get message count and data
2736:
2737: OE_MSG_PUB.Count_And_Get
2738: ( p_count => x_msg_count
2739: , p_data => x_msg_data
2740: );
2741:
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748:
2749: -- Get message count and data
2750:
2751: OE_MSG_PUB.Count_And_Get
2752: ( p_count => x_msg_count
2753: , p_data => x_msg_data
2754: );
2755:
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2759:
2760: -- Get message count and data
2761:
2762: OE_MSG_PUB.Count_And_Get
2763: ( p_count => x_msg_count
2764: , p_data => x_msg_data
2765: );
2766:
2767: WHEN OTHERS THEN
2768:
2769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2770:
2771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2772: THEN
2773: OE_MSG_PUB.Add_Exc_Msg
2774: ( G_PKG_NAME
2775: , 'Get_Attr_Mapping'
2769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2770:
2771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2772: THEN
2773: OE_MSG_PUB.Add_Exc_Msg
2774: ( G_PKG_NAME
2775: , 'Get_Attr_Mapping'
2776: );
2777: END IF;
2777: END IF;
2778:
2779: -- Get message count and data
2780:
2781: OE_MSG_PUB.Count_And_Get
2782: ( p_count => x_msg_count
2783: , p_data => x_msg_data
2784: );
2785:
2817: ,p_delete => FND_API.G_TRUE
2818: ,x_return_status => x_return_status
2819: );
2820:
2821: oe_msg_pub.Count_And_Get
2822: ( p_count => x_msg_count
2823: , p_data => x_msg_data
2824: );
2825: