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);
777: IF (l_busdocs_tbl.COUNT >= 1) THEN
778:
779: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
780: p_api_version => 1.0,
781: p_init_msg_list => FND_API.G_FALSE,
782: p_commit => FND_API.G_FALSE,
783: p_bus_docs_tbl => l_busdocs_tbl,
784: p_original_internal_contact_id => p_old_personid,
785: p_new_internal_contact_id => p_new_personid,
778:
779: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
780: p_api_version => 1.0,
781: p_init_msg_list => FND_API.G_FALSE,
782: p_commit => FND_API.G_FALSE,
783: p_bus_docs_tbl => l_busdocs_tbl,
784: p_original_internal_contact_id => p_old_personid,
785: p_new_internal_contact_id => p_new_personid,
786: x_msg_data => p_msg_data,
786: x_msg_data => p_msg_data,
787: x_msg_count => p_msg_count,
788: x_return_status => p_return_status);
789:
790: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
791:
792: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794:
789:
790: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
791:
792: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count,p_data => p_msg_data);
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794:
795: END IF;
796:
797: END IF;
817: END IF;
818:
819: ROLLBACK TO Update_Buyer_REC_PO_SP;
820:
821: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
824:
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
840: IF (l_busdocs_tbl.COUNT >= 1) THEN
841:
842: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
843: p_api_version => 1.0,
844: p_init_msg_list => FND_API.G_FALSE,
845: p_commit => FND_API.G_FALSE,
846: p_bus_docs_tbl => l_busdocs_tbl,
847: p_original_internal_contact_id => p_old_personid,
848: p_new_internal_contact_id => p_new_personid,
841:
842: okc_manage_deliverables_grp.updateIntContactOnDeliverables (
843: p_api_version => 1.0,
844: p_init_msg_list => FND_API.G_FALSE,
845: p_commit => FND_API.G_FALSE,
846: p_bus_docs_tbl => l_busdocs_tbl,
847: p_original_internal_contact_id => p_old_personid,
848: p_new_internal_contact_id => p_new_personid,
849: x_msg_data => p_msg_data,
849: x_msg_data => p_msg_data,
850: x_msg_count => p_msg_count,
851: x_return_status => p_return_status);
852:
853: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
854:
855: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
856: ,p_data => p_msg_data);
857:
854:
855: FND_MSG_PUB.Count_and_Get(p_count => p_msg_count
856: ,p_data => p_msg_data);
857:
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859:
860: END IF;
861:
862: END IF;
1127: END IF;
1128:
1129: ROLLBACK TO Update_Buyer_REC_REL_SP;
1130:
1131: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132:
1133: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1134:
1135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1157: END IF;
1158:
1159: ROLLBACK TO PO_Mass_Update_Buyer_SP;
1160:
1161: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1162:
1163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1164:
1165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1290: p_msg_data,
1291: p_msg_count,
1292: p_return_status);
1293:
1294: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1295: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: RETURN;
1297: END IF;
1298:
1291: p_msg_count,
1292: p_return_status);
1293:
1294: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1295: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: RETURN;
1297: END IF;
1298:
1299:
1354: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
1355:
1356: END IF;
1357:
1358: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359:
1360: FND_MSG_PUB.Count_And_Get(
1361: p_count => p_msg_count,
1362: p_data => p_msg_data);
1540: END IF;
1541:
1542: ROLLBACK TO Mass_Update_Forward_SP;
1543:
1544: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545:
1546: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1547:
1548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1742: END IF;
1743:
1744: ROLLBACK TO Mass_Update_Forward_SP;
1745:
1746: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1747:
1748: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1749:
1750: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1772: END IF;
1773:
1774: ROLLBACK TO PO_Mass_Update_Approver_SP;
1775:
1776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1777:
1778: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1779:
1780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
1904: p_msg_data,
1905: p_msg_count,
1906: p_return_status);
1907:
1908: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1910: RETURN;
1911: END IF;
1912:
1905: p_msg_count,
1906: p_return_status);
1907:
1908: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1910: RETURN;
1911: END IF;
1912:
1913:
1963: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_log_head,l_progress|| SQLCODE || SUBSTR(SQLERRM,1,200));
1964:
1965: END IF;
1966:
1967: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1968:
1969: FND_MSG_PUB.Count_And_Get(
1970: p_count => p_msg_count,
1971: p_data => p_msg_data);
2157: END IF;
2158:
2159: ROLLBACK TO Update_DeliverTo_RECPO_SP;
2160:
2161: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2162:
2163: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2164:
2165: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2362: END IF;
2363:
2364: ROLLBACK TO Update_DeliverTo_RECREL_SP;
2365:
2366: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2367:
2368: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2369:
2370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2392: END IF;
2393:
2394: ROLLBACK TO PO_Mass_Update_DeliverTo_SP;
2395:
2396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2397:
2398: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2399:
2400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2602: END IF;
2603:
2604: ROLLBACK TO Print_SP;
2605:
2606: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2607:
2608: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2609:
2610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );
2787: END IF;
2788:
2789: ROLLBACK TO Buyer_Info_SP;
2790:
2791: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792:
2793: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2794:
2795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_log_head );