136: p_msg_data,
137: p_msg_count,
138: l_return_status);
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: ROLLBACK TO PO_Mass_Update_Buyer_SP;
142: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END IF;
144:
138: l_return_status);
139:
140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
141: ROLLBACK TO PO_Mass_Update_Buyer_SP;
142: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END IF;
144:
145: END IF;
146:
155: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
156:
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);
194: p_msg_data,
195: p_msg_count,
196: l_return_status);
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: ROLLBACK TO PO_Mass_Update_Approver_SP;
200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: END IF;
202:
196: l_return_status);
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: ROLLBACK TO PO_Mass_Update_Approver_SP;
200: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: END IF;
202:
203:
204: EXCEPTION
212: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
213:
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);
251: p_msg_data,
252: p_msg_count,
253: l_return_status);
254:
255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: ROLLBACK TO PO_Mass_Update_Deliver_To_SP;
257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: END IF;
259:
253: l_return_status);
254:
255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
256: ROLLBACK TO PO_Mass_Update_Deliver_To_SP;
257: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: END IF;
259:
260:
261:
271: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
272:
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);
293: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
294:
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);
444: p_msg_data,
445: p_msg_count,
446: p_return_status);
447:
448: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: RETURN;
451: END IF;
452:
445: p_msg_count,
446: p_return_status);
447:
448: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: RETURN;
451: END IF;
452:
453:
503: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
504:
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);
832: IF (l_busdocs_tbl.COUNT >= 1) THEN
833:
834: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
835: p_api_version => 1.0,
836: p_init_msg_list => FND_API.G_FALSE,
837: p_commit => FND_API.G_FALSE,
838: p_bus_docs_tbl => l_busdocs_tbl,
839: p_original_internal_contact_id => p_old_personid,
840: p_new_internal_contact_id => p_new_personid,
833:
834: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
835: p_api_version => 1.0,
836: p_init_msg_list => FND_API.G_FALSE,
837: p_commit => FND_API.G_FALSE,
838: p_bus_docs_tbl => l_busdocs_tbl,
839: p_original_internal_contact_id => p_old_personid,
840: p_new_internal_contact_id => p_new_personid,
841: x_msg_data => p_msg_data,
841: x_msg_data => p_msg_data,
842: x_msg_count => p_msg_count,
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:
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:
852: END IF;
872: END IF;
873:
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 );
895: IF (l_busdocs_tbl.COUNT >= 1) THEN
896:
897: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
898: p_api_version => 1.0,
899: p_init_msg_list => FND_API.G_FALSE,
900: p_commit => FND_API.G_FALSE,
901: p_bus_docs_tbl => l_busdocs_tbl,
902: p_original_internal_contact_id => p_old_personid,
903: p_new_internal_contact_id => p_new_personid,
896:
897: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
898: p_api_version => 1.0,
899: p_init_msg_list => FND_API.G_FALSE,
900: p_commit => FND_API.G_FALSE,
901: p_bus_docs_tbl => l_busdocs_tbl,
902: p_original_internal_contact_id => p_old_personid,
903: p_new_internal_contact_id => p_new_personid,
904: x_msg_data => p_msg_data,
904: x_msg_data => p_msg_data,
905: x_msg_count => p_msg_count,
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:
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:
915: END IF;
916:
917: END IF;
1200: END IF;
1201:
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 );
1230: END IF;
1231:
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 );
1363: p_msg_data,
1364: p_msg_count,
1365: p_return_status);
1366:
1367: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: RETURN;
1370: END IF;
1371:
1364: p_msg_count,
1365: p_return_status);
1366:
1367: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1368: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: RETURN;
1370: END IF;
1371:
1372:
1427: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
1428:
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);
1613: END IF;
1614:
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 );
1815: END IF;
1816:
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 );
1845: END IF;
1846:
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 );
1977: p_msg_data,
1978: p_msg_count,
1979: p_return_status);
1980:
1981: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1983: RETURN;
1984: END IF;
1985:
1978: p_msg_count,
1979: p_return_status);
1980:
1981: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1982: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1983: RETURN;
1984: END IF;
1985:
1986:
2036: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
2037:
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);
2230: END IF;
2231:
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 );
2435: END IF;
2436:
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 );
2465: END IF;
2466:
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 );
2675: END IF;
2676:
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 );
2908: END IF;
2909:
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 );