157: END IF;
158:
159: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160:
161: FND_MSG_PUB.Count_And_Get(
162: p_count => p_msg_count,
163: p_data => p_msg_data);
164:
165: END;
214: END IF;
215:
216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217:
218: FND_MSG_PUB.Count_And_Get(
219: p_count => p_msg_count,
220: p_data => p_msg_data);
221:
222: END;
273: END IF;
274:
275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: FND_MSG_PUB.Count_And_Get(
278: p_count => p_msg_count,
279: p_data => p_msg_data);
280:
281: END;
295: END IF;
296:
297: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: FND_MSG_PUB.Count_And_Get(
300: p_count => p_msg_count,
301: p_data => p_msg_data);
302:
303: END DO_Update;
505: END IF;
506:
507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: FND_MSG_PUB.Count_And_Get(
510: p_count => p_msg_count,
511: p_data => p_msg_data);
512:
513: END;
843: x_return_status => p_return_status);
844:
845: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846:
847: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849:
850: END IF;
851:
874: ROLLBACK TO Update_Buyer_REC_PO_SP;
875:
876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877:
878: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
879:
880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
881:
882: END IF;
876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877:
878: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
879:
880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
881:
882: END IF;
883:
884: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
880: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
881:
882: END IF;
883:
884: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
885:
886: END;
887:
888:
906: x_return_status => p_return_status);
907:
908: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
909:
910: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
911: ,p_data => p_msg_data);
912:
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914:
1202: ROLLBACK TO Update_Buyer_REC_REL_SP;
1203:
1204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1207:
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1209:
1210: END IF;
1204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205:
1206: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1207:
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1209:
1210: END IF;
1211:
1212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1209:
1210: END IF;
1211:
1212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1213:
1214: END;
1215:
1216: END LOOP;
1232: ROLLBACK TO PO_Mass_Update_Buyer_SP;
1233:
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1235:
1236: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1237:
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1239:
1240: END IF;
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1235:
1236: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1237:
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1239:
1240: END IF;
1241:
1242: END Update_Buyer;
1429: END IF;
1430:
1431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432:
1433: FND_MSG_PUB.Count_And_Get(
1434: p_count => p_msg_count,
1435: p_data => p_msg_data);
1436:
1437: END;
1615: ROLLBACK TO Mass_Update_Forward_SP;
1616:
1617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1618:
1619: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1620:
1621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1622:
1623: END IF;
1617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1618:
1619: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1620:
1621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1622:
1623: END IF;
1624:
1625: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1622:
1623: END IF;
1624:
1625: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1626:
1627:
1628: END;
1629:
1817: ROLLBACK TO Mass_Update_Forward_SP;
1818:
1819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1820:
1821: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1822:
1823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1824:
1825: END IF;
1819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1820:
1821: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1822:
1823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1824:
1825: END IF;
1826:
1827: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1824:
1825: END IF;
1826:
1827: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1828:
1829: END;
1830:
1831: END LOOP;
1847: ROLLBACK TO PO_Mass_Update_Approver_SP;
1848:
1849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1850:
1851: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1852:
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1854:
1855: END IF;
1849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1850:
1851: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1852:
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1854:
1855: END IF;
1856:
1857: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1853: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1854:
1855: END IF;
1856:
1857: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
1858:
1859: END Update_Approver;
1860:
1861: --------------------------------------------------------------------------------------------------
2038: END IF;
2039:
2040: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2041:
2042: FND_MSG_PUB.Count_And_Get(
2043: p_count => p_msg_count,
2044: p_data => p_msg_data);
2045:
2046: END;
2232: ROLLBACK TO Update_DeliverTo_RECPO_SP;
2233:
2234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2235:
2236: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2237:
2238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2239:
2240: END IF;
2234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2235:
2236: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2237:
2238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2239:
2240: END IF;
2241:
2242: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2239:
2240: END IF;
2241:
2242: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2243:
2244: END;
2245:
2246: END LOOP;
2437: ROLLBACK TO Update_DeliverTo_RECREL_SP;
2438:
2439: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2440:
2441: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2442:
2443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2444:
2445: END IF;
2439: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2440:
2441: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2442:
2443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2444:
2445: END IF;
2446:
2447: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2444:
2445: END IF;
2446:
2447: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2448:
2449: END;
2450:
2451: END LOOP;
2467: ROLLBACK TO PO_Mass_Update_DeliverTo_SP;
2468:
2469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2470:
2471: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2472:
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2474:
2475: END IF;
2469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2470:
2471: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2472:
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2474:
2475: END IF;
2476:
2477: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2474:
2475: END IF;
2476:
2477: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2478:
2479: END Update_Deliver_To;
2480:
2481: --------------------------------------------------------------------------------------------------
2677: ROLLBACK TO Print_SP;
2678:
2679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2680:
2681: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2682:
2683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2684:
2685: END IF;
2679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2680:
2681: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2682:
2683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2684:
2685: END IF;
2686:
2687: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2684:
2685: END IF;
2686:
2687: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2688:
2689: END Print_Output;
2690:
2691: --------------------------------------------------------------------------------------------------
2910: ROLLBACK TO Buyer_Info_SP;
2911:
2912: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2913:
2914: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2915:
2916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2917:
2918: END IF;
2912: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2913:
2914: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2915:
2916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2917:
2918: END IF;
2919:
2920: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2916: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2917:
2918: END IF;
2919:
2920: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => p_msg_count, p_data => p_msg_data );
2921:
2922: END Buyer_Info;
2923:
2924: --------------------------------------------------------------------------------------------------