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.

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_MOD_SYNC_PROCESS_PVT');

1: PACKAGE BODY PO_MOD_SYNC_PROCESS_PVT AS
2: /* $Header: PO_MOD_SYNC_PROCESS_PVT.plb 120.20.12020000.5 2013/04/18 04:37:36 amalick ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_MOD_SYNC_PROCESS_PVT');
6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DRAFT_MERGE_PKG';
8: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
9:

Line 996: IF (PO_LOG.d_proc) THEN

992: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
993: BEGIN
994:
995: d_position := 0;
996: IF (PO_LOG.d_proc) THEN
997: PO_LOG.proc_begin(d_module);
998: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
999: END IF;
1000:

Line 997: PO_LOG.proc_begin(d_module);

993: BEGIN
994:
995: d_position := 0;
996: IF (PO_LOG.d_proc) THEN
997: PO_LOG.proc_begin(d_module);
998: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
999: END IF;
1000:
1001: --chk if uda enabled

Line 998: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

994:
995: d_position := 0;
996: IF (PO_LOG.d_proc) THEN
997: PO_LOG.proc_begin(d_module);
998: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
999: END IF;
1000:
1001: --chk if uda enabled
1002: SELECT document_id

Line 1013: IF PO_LOG.d_stmt THEN

1009: FROM po_headers_all
1010: WHERE PO_HEADER_ID = l_po_header_id;
1011:
1012: d_position := 70;
1013: IF PO_LOG.d_stmt THEN
1014: PO_LOG.stmt(d_module,d_position,'Before Check_Uda_Enabled');
1015: END IF;
1016:
1017: PO_CLM_CLO_UTIL.Check_po_Uda_Enabled

Line 1014: PO_LOG.stmt(d_module,d_position,'Before Check_Uda_Enabled');

1010: WHERE PO_HEADER_ID = l_po_header_id;
1011:
1012: d_position := 70;
1013: IF PO_LOG.d_stmt THEN
1014: PO_LOG.stmt(d_module,d_position,'Before Check_Uda_Enabled');
1015: END IF;
1016:
1017: PO_CLM_CLO_UTIL.Check_po_Uda_Enabled
1018: (

Line 1026: IF PO_LOG.d_stmt THEN

1022: ,x_return_status => l_return_status
1023: );
1024:
1025: d_position := 80;
1026: IF PO_LOG.d_stmt THEN
1027: PO_LOG.stmt(d_module,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
1028: END IF;
1029:
1030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1027: PO_LOG.stmt(d_module,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);

1023: );
1024:
1025: d_position := 80;
1026: IF PO_LOG.d_stmt THEN
1027: PO_LOG.stmt(d_module,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
1028: END IF;
1029:
1030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1040: IF (PO_LOG.d_stmt) THEN

1036: ,p_uda_enabled_flag => l_enabled_flag
1037: ,x_return_status => x_return_status
1038: );
1039: d_position := 20;
1040: IF (PO_LOG.d_stmt) THEN
1041: PO_LOG.stmt(d_module,d_position ,'Sync_headers successful');
1042: END IF;
1043:
1044: -- update lines

Line 1041: PO_LOG.stmt(d_module,d_position ,'Sync_headers successful');

1037: ,x_return_status => x_return_status
1038: );
1039: d_position := 20;
1040: IF (PO_LOG.d_stmt) THEN
1041: PO_LOG.stmt(d_module,d_position ,'Sync_headers successful');
1042: END IF;
1043:
1044: -- update lines
1045: sync_lines(p_draft_id => p_draft_id

Line 1051: IF (PO_LOG.d_stmt) THEN

1047: ,x_return_status => x_return_status
1048: );
1049:
1050: d_position := 40;
1051: IF (PO_LOG.d_stmt) THEN
1052: PO_LOG.stmt(d_module,d_position ,'sync_lines successful');
1053: END IF;
1054:
1055: --update shipments

Line 1052: PO_LOG.stmt(d_module,d_position ,'sync_lines successful');

1048: );
1049:
1050: d_position := 40;
1051: IF (PO_LOG.d_stmt) THEN
1052: PO_LOG.stmt(d_module,d_position ,'sync_lines successful');
1053: END IF;
1054:
1055: --update shipments
1056: sync_shipments(p_draft_id => p_draft_id

Line 1062: IF (PO_LOG.d_stmt) THEN

1058: ,x_return_status => x_return_status
1059: );
1060:
1061: d_position := 60;
1062: IF (PO_LOG.d_stmt) THEN
1063: PO_LOG.stmt(d_module,d_position ,'sync_shipments successful');
1064: END IF;
1065:
1066: -- update distributions

Line 1063: PO_LOG.stmt(d_module,d_position ,'sync_shipments successful');

1059: );
1060:
1061: d_position := 60;
1062: IF (PO_LOG.d_stmt) THEN
1063: PO_LOG.stmt(d_module,d_position ,'sync_shipments successful');
1064: END IF;
1065:
1066: -- update distributions
1067: sync_distributions(

Line 1073: IF (PO_LOG.d_stmt) THEN

1069: ,x_return_status => x_return_status
1070: );
1071:
1072: d_position := 60;
1073: IF (PO_LOG.d_stmt) THEN
1074: PO_LOG.stmt(d_module,d_position ,'sync_distributions successful');
1075: END IF;
1076:
1077: -- Update the revision_num on po_drafts table.

Line 1074: PO_LOG.stmt(d_module,d_position ,'sync_distributions successful');

1070: );
1071:
1072: d_position := 60;
1073: IF (PO_LOG.d_stmt) THEN
1074: PO_LOG.stmt(d_module,d_position ,'sync_distributions successful');
1075: END IF;
1076:
1077: -- Update the revision_num on po_drafts table.
1078: -- This can be updated to -1 from update without Mod flow.

Line 1085: IF (PO_LOG.d_proc) THEN

1081: WHERE draft_id = p_draft_id
1082: AND revision_num = -1;
1083:
1084: d_position := 80;
1085: IF (PO_LOG.d_proc) THEN
1086: PO_LOG.proc_end(d_module);
1087: END IF;
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:

Line 1086: PO_LOG.proc_end(d_module);

1082: AND revision_num = -1;
1083:
1084: d_position := 80;
1085: IF (PO_LOG.d_proc) THEN
1086: PO_LOG.proc_end(d_module);
1087: END IF;
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:
1090: EXCEPTION

Line 1093: IF (PO_LOG.d_exc) THEN

1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (PO_LOG.d_exc) THEN
1094: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1095: END IF;
1096: RAISE;
1097: END sync_mod_updatable_attrs;

Line 1094: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (PO_LOG.d_exc) THEN
1094: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1095: END IF;
1096: RAISE;
1097: END sync_mod_updatable_attrs;
1098: --END

Line 1160: IF (PO_LOG.d_proc) THEN

1156: l_delete_flag_tbl:=Po_Tbl_Varchar1();
1157: l_record_already_exist_tbl:=Po_Tbl_Varchar1();
1158: l_change_status_tbl :=PO_TBL_VARCHAR30();
1159: d_position := 0;
1160: IF (PO_LOG.d_proc) THEN
1161: PO_LOG.proc_begin(d_module);
1162: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
1163: END IF;
1164:

Line 1161: PO_LOG.proc_begin(d_module);

1157: l_record_already_exist_tbl:=Po_Tbl_Varchar1();
1158: l_change_status_tbl :=PO_TBL_VARCHAR30();
1159: d_position := 0;
1160: IF (PO_LOG.d_proc) THEN
1161: PO_LOG.proc_begin(d_module);
1162: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
1163: END IF;
1164:
1165:

Line 1162: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

1158: l_change_status_tbl :=PO_TBL_VARCHAR30();
1159: d_position := 0;
1160: IF (PO_LOG.d_proc) THEN
1161: PO_LOG.proc_begin(d_module);
1162: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
1163: END IF;
1164:
1165:
1166: SELECT document_id

Line 1172: IF (PO_LOG.d_stmt) THEN

1168: FROM po_drafts
1169: WHERE draft_id = p_draft_id;
1170:
1171: d_position := 10;
1172: IF (PO_LOG.d_stmt) THEN
1173: PO_LOG.stmt(d_module,d_position ,'Document Header ID', l_po_header_id);
1174: END IF;
1175:
1176: /*amount limit and old amount limit are the concurrent update attributes for header*/

Line 1173: PO_LOG.stmt(d_module,d_position ,'Document Header ID', l_po_header_id);

1169: WHERE draft_id = p_draft_id;
1170:
1171: d_position := 10;
1172: IF (PO_LOG.d_stmt) THEN
1173: PO_LOG.stmt(d_module,d_position ,'Document Header ID', l_po_header_id);
1174: END IF;
1175:
1176: /*amount limit and old amount limit are the concurrent update attributes for header*/
1177: SELECT phd.revision_num,

Line 1196: IF (PO_LOG.d_stmt) THEN

1192: AND phd.draft_id = p_draft_id
1193: AND pha.po_header_id = l_po_header_id;
1194:
1195: d_position := 20;
1196: IF (PO_LOG.d_stmt) THEN
1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);
1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);
1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);

Line 1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);

1193: AND pha.po_header_id = l_po_header_id;
1194:
1195: d_position := 20;
1196: IF (PO_LOG.d_stmt) THEN
1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);
1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);
1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);
1201: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_limit);

Line 1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);

1194:
1195: d_position := 20;
1196: IF (PO_LOG.d_stmt) THEN
1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);
1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);
1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);
1201: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_limit);
1202: END IF;

Line 1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);

1195: d_position := 20;
1196: IF (PO_LOG.d_stmt) THEN
1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);
1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);
1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);
1201: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_limit);
1202: END IF;
1203:

Line 1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);

1196: IF (PO_LOG.d_stmt) THEN
1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);
1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);
1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);
1201: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_limit);
1202: END IF;
1203:
1204: /* fetch the rev_num */

Line 1201: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_limit);

1197: PO_LOG.stmt(d_module,d_position ,'Draft Header Revision Num', l_header_draft_rev_num);
1198: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1199: PO_LOG.stmt(d_module,d_position ,'Base Amount Limit', l_base_amount_limit);
1200: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_limit);
1201: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_limit);
1202: END IF;
1203:
1204: /* fetch the rev_num */
1205: SELECT revision_num

Line 1224: IF (PO_LOG.d_stmt) THEN

1220: l_lock_type := NULL;
1221: END;
1222:
1223: d_position := 20;
1224: IF (PO_LOG.d_stmt) THEN
1225: PO_LOG.stmt(d_module,d_position ,'PODraft revision Number', l_draft_rev_num);
1226: PO_LOG.stmt(d_module,d_position ,'lock_type', l_lock_type);
1227: END IF;
1228:

Line 1225: PO_LOG.stmt(d_module,d_position ,'PODraft revision Number', l_draft_rev_num);

1221: END;
1222:
1223: d_position := 20;
1224: IF (PO_LOG.d_stmt) THEN
1225: PO_LOG.stmt(d_module,d_position ,'PODraft revision Number', l_draft_rev_num);
1226: PO_LOG.stmt(d_module,d_position ,'lock_type', l_lock_type);
1227: END IF;
1228:
1229: /*if the draft revision num is less than base revision num then a sync is required*/

Line 1226: PO_LOG.stmt(d_module,d_position ,'lock_type', l_lock_type);

1222:
1223: d_position := 20;
1224: IF (PO_LOG.d_stmt) THEN
1225: PO_LOG.stmt(d_module,d_position ,'PODraft revision Number', l_draft_rev_num);
1226: PO_LOG.stmt(d_module,d_position ,'lock_type', l_lock_type);
1227: END IF;
1228:
1229: /*if the draft revision num is less than base revision num then a sync is required*/
1230: IF( p_ignore_rev_number = 'Y' OR (l_header_draft_rev_num < l_header_base_rev_num OR l_draft_rev_num = -1)) THEN

Line 1348: IF (PO_LOG.d_stmt) THEN

1344: WHERE pohd.po_header_id=l_po_header_id
1345: AND pohd.draft_id = p_draft_id;
1346:
1347: d_position := 40;
1348: IF (PO_LOG.d_stmt) THEN
1349: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
1350: PO_LOG.stmt(d_module,d_position ,'synced header for S or No locks');
1351: END IF;
1352:

Line 1349: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

1345: AND pohd.draft_id = p_draft_id;
1346:
1347: d_position := 40;
1348: IF (PO_LOG.d_stmt) THEN
1349: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
1350: PO_LOG.stmt(d_module,d_position ,'synced header for S or No locks');
1351: END IF;
1352:
1353: IF p_uda_enabled_flag='Y' THEN

Line 1350: PO_LOG.stmt(d_module,d_position ,'synced header for S or No locks');

1346:
1347: d_position := 40;
1348: IF (PO_LOG.d_stmt) THEN
1349: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
1350: PO_LOG.stmt(d_module,d_position ,'synced header for S or No locks');
1351: END IF;
1352:
1353: IF p_uda_enabled_flag='Y' THEN
1354: sync_headers_ext(

Line 1361: IF (PO_LOG.d_stmt) THEN

1357: );
1358: END IF;
1359:
1360: d_position := 50;
1361: IF (PO_LOG.d_stmt) THEN
1362: PO_LOG.stmt(d_module,d_position ,'synced Header_ext tables');
1363: END IF;
1364:
1365: /* Sync records coresponding to po_ga_org_assignments */

Line 1362: PO_LOG.stmt(d_module,d_position ,'synced Header_ext tables');

1358: END IF;
1359:
1360: d_position := 50;
1361: IF (PO_LOG.d_stmt) THEN
1362: PO_LOG.stmt(d_module,d_position ,'synced Header_ext tables');
1363: END IF;
1364:
1365: /* Sync records coresponding to po_ga_org_assignments */
1366: --delete the recored from po_ga_org_assign_draft for the given header_id and draft_id

Line 1399: IF (PO_LOG.d_stmt) THEN

1395: WHERE pgoad.org_assignment_id = l_org_assignment_id_tbl(i)
1396: AND pgoad.draft_id = p_draft_id ;
1397:
1398: d_position := 60;
1399: IF (PO_LOG.d_stmt) THEN
1400: PO_LOG.stmt(d_module,d_position ,'PO_GA_ORG_ASSIGN_DRAFT_PKG.sync_draft_from_txn');
1401: END IF;
1402:
1403: /* Sync records coresponding to po_notification_controls */

Line 1400: PO_LOG.stmt(d_module,d_position ,'PO_GA_ORG_ASSIGN_DRAFT_PKG.sync_draft_from_txn');

1396: AND pgoad.draft_id = p_draft_id ;
1397:
1398: d_position := 60;
1399: IF (PO_LOG.d_stmt) THEN
1400: PO_LOG.stmt(d_module,d_position ,'PO_GA_ORG_ASSIGN_DRAFT_PKG.sync_draft_from_txn');
1401: END IF;
1402:
1403: /* Sync records coresponding to po_notification_controls */
1404: --delete the recored from po_notification_ctrl_draft for the given header_id and draft_id

Line 1442: IF (PO_LOG.d_stmt) THEN

1438: WHERE pncd.notification_id=l_notification_id_tbl(i)
1439: AND pncd.draft_id = p_draft_id ;
1440:
1441: d_position := 70;
1442: IF (PO_LOG.d_stmt) THEN
1443: PO_LOG.stmt(d_module,d_position ,'PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn');
1444: END IF;
1445:
1446: END IF; --IF( p_ignore_rev_number = 'Y' OR ( l_lock_type = 'S' OR l_lock_type IS NULL))

Line 1443: PO_LOG.stmt(d_module,d_position ,'PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn');

1439: AND pncd.draft_id = p_draft_id ;
1440:
1441: d_position := 70;
1442: IF (PO_LOG.d_stmt) THEN
1443: PO_LOG.stmt(d_module,d_position ,'PO_NOTIFICATION_CTRL_DRAFT_PKG.sync_draft_from_txn');
1444: END IF;
1445:
1446: END IF; --IF( p_ignore_rev_number = 'Y' OR ( l_lock_type = 'S' OR l_lock_type IS NULL))
1447:

Line 1463: IF (PO_LOG.d_stmt) THEN

1459: END IF;
1460: END IF;--IF l_lock_type IN ('S','P')
1461:
1462: d_position := 80;
1463: IF (PO_LOG.d_stmt) THEN
1464:
1465: PO_LOG.stmt(d_module,d_position ,'updated old_amount_limit', l_base_amount_limit);
1466: PO_LOG.stmt(d_module,d_position ,'updated amount_limit', l_base_amount_limit +
1467: (l_draft_amount_limit-l_draft_old_amount_limit));

Line 1465: PO_LOG.stmt(d_module,d_position ,'updated old_amount_limit', l_base_amount_limit);

1461:
1462: d_position := 80;
1463: IF (PO_LOG.d_stmt) THEN
1464:
1465: PO_LOG.stmt(d_module,d_position ,'updated old_amount_limit', l_base_amount_limit);
1466: PO_LOG.stmt(d_module,d_position ,'updated amount_limit', l_base_amount_limit +
1467: (l_draft_amount_limit-l_draft_old_amount_limit));
1468: END IF;
1469:

Line 1466: PO_LOG.stmt(d_module,d_position ,'updated amount_limit', l_base_amount_limit +

1462: d_position := 80;
1463: IF (PO_LOG.d_stmt) THEN
1464:
1465: PO_LOG.stmt(d_module,d_position ,'updated old_amount_limit', l_base_amount_limit);
1466: PO_LOG.stmt(d_module,d_position ,'updated amount_limit', l_base_amount_limit +
1467: (l_draft_amount_limit-l_draft_old_amount_limit));
1468: END IF;
1469:
1470: IF p_uda_enabled_flag='Y'

Line 1481: IF (PO_LOG.d_stmt) THEN

1477: );
1478: END IF;
1479:
1480: d_position := 90;
1481: IF (PO_LOG.d_stmt) THEN
1482: PO_LOG.stmt(d_module,d_position ,'synced uda_address tables');
1483: END IF;
1484:
1485: /*we need to update revision_num , change_status*/

Line 1482: PO_LOG.stmt(d_module,d_position ,'synced uda_address tables');

1478: END IF;
1479:
1480: d_position := 90;
1481: IF (PO_LOG.d_stmt) THEN
1482: PO_LOG.stmt(d_module,d_position ,'synced uda_address tables');
1483: END IF;
1484:
1485: /*we need to update revision_num , change_status*/
1486: UPDATE po_headers_draft_all

Line 1493: IF (PO_LOG.d_stmt) THEN

1489: WHERE po_header_id = l_po_header_id
1490: AND draft_id = p_draft_id;
1491:
1492: d_position := 80;
1493: IF (PO_LOG.d_stmt) THEN
1494: PO_LOG.stmt(d_module,d_position ,'updated revision_num', l_header_base_rev_num);
1495: END IF;
1496:
1497: END IF;--IF( p_ignore_rev_number = 'Y' OR (l_header_draft_rev_num < l_header_base_rev_num OR l_draft_rev_num = -1))

Line 1494: PO_LOG.stmt(d_module,d_position ,'updated revision_num', l_header_base_rev_num);

1490: AND draft_id = p_draft_id;
1491:
1492: d_position := 80;
1493: IF (PO_LOG.d_stmt) THEN
1494: PO_LOG.stmt(d_module,d_position ,'updated revision_num', l_header_base_rev_num);
1495: END IF;
1496:
1497: END IF;--IF( p_ignore_rev_number = 'Y' OR (l_header_draft_rev_num < l_header_base_rev_num OR l_draft_rev_num = -1))
1498:

Line 1500: IF (PO_LOG.d_proc) THEN

1496:
1497: END IF;--IF( p_ignore_rev_number = 'Y' OR (l_header_draft_rev_num < l_header_base_rev_num OR l_draft_rev_num = -1))
1498:
1499: d_position := 100;
1500: IF (PO_LOG.d_proc) THEN
1501: PO_LOG.proc_end(d_module);
1502: END IF;
1503:
1504: EXCEPTION

Line 1501: PO_LOG.proc_end(d_module);

1497: END IF;--IF( p_ignore_rev_number = 'Y' OR (l_header_draft_rev_num < l_header_base_rev_num OR l_draft_rev_num = -1))
1498:
1499: d_position := 100;
1500: IF (PO_LOG.d_proc) THEN
1501: PO_LOG.proc_end(d_module);
1502: END IF;
1503:
1504: EXCEPTION
1505: WHEN OTHERS THEN

Line 1507: IF (PO_LOG.d_exc) THEN

1503:
1504: EXCEPTION
1505: WHEN OTHERS THEN
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: IF (PO_LOG.d_exc) THEN
1508: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1509: END IF;
1510: RAISE;
1511: END sync_headers;

Line 1508: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

1504: EXCEPTION
1505: WHEN OTHERS THEN
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: IF (PO_LOG.d_exc) THEN
1508: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1509: END IF;
1510: RAISE;
1511: END sync_headers;
1512:

Line 1599: IF (PO_LOG.d_proc) THEN

1595: l_draft_CLM_UNDEF_FLAG_tbl := Po_Tbl_varchar1(); --bug 16451273
1596: l_po_line_s_no_p_lck_tbl := po_tbl_number(); --
1597:
1598: d_position := 0;
1599: IF (PO_LOG.d_proc) THEN
1600: PO_LOG.proc_begin(d_module);
1601: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
1602: END IF;
1603:

Line 1600: PO_LOG.proc_begin(d_module);

1596: l_po_line_s_no_p_lck_tbl := po_tbl_number(); --
1597:
1598: d_position := 0;
1599: IF (PO_LOG.d_proc) THEN
1600: PO_LOG.proc_begin(d_module);
1601: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
1602: END IF;
1603:
1604: -- 1. Identify lines which P, S or no lock which needs to be synced

Line 1601: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

1597:
1598: d_position := 0;
1599: IF (PO_LOG.d_proc) THEN
1600: PO_LOG.proc_begin(d_module);
1601: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
1602: END IF;
1603:
1604: -- 1. Identify lines which P, S or no lock which needs to be synced
1605: -- Collect quantity and amount for all such lines

Line 1648: IF (PO_LOG.d_stmt) THEN

1644: AND pel.lock_by_draft_id = plda.draft_id
1645: AND pel.lock_type = 'F');
1646:
1647: d_position := 20;
1648: IF (PO_LOG.d_stmt) THEN
1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);

Line 1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);

1645: AND pel.lock_type = 'F');
1646:
1647: d_position := 20;
1648: IF (PO_LOG.d_stmt) THEN
1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);

Line 1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);

1646:
1647: d_position := 20;
1648: IF (PO_LOG.d_stmt) THEN
1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);

Line 1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);

1647: d_position := 20;
1648: IF (PO_LOG.d_stmt) THEN
1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);

Line 1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);

1648: IF (PO_LOG.d_stmt) THEN
1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);
1656: PO_LOG.stmt(d_module,d_position ,'po_line_id', l_po_line_id_tbl);

Line 1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);

1649: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);
1656: PO_LOG.stmt(d_module,d_position ,'po_line_id', l_po_line_id_tbl);
1657: END IF;

Line 1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);

1650: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);
1656: PO_LOG.stmt(d_module,d_position ,'po_line_id', l_po_line_id_tbl);
1657: END IF;
1658:

Line 1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);

1651: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);
1656: PO_LOG.stmt(d_module,d_position ,'po_line_id', l_po_line_id_tbl);
1657: END IF;
1658:
1659: -- 2. Identify lines with S lock or no lock which needs to be synced

Line 1656: PO_LOG.stmt(d_module,d_position ,'po_line_id', l_po_line_id_tbl);

1652: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
1653: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
1654: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
1655: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_po_line_id_tbl);
1656: PO_LOG.stmt(d_module,d_position ,'po_line_id', l_po_line_id_tbl);
1657: END IF;
1658:
1659: -- 2. Identify lines with S lock or no lock which needs to be synced
1660: SELECT plda.po_line_id,

Line 1678: IF (PO_LOG.d_stmt) THEN

1674: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY
1675: AND pel.lock_by_draft_id = plda.draft_id
1676: AND pel.lock_type IN ('F', 'P'));
1677: d_position := 40;
1678: IF (PO_LOG.d_stmt) THEN
1679: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks', l_po_line_s_no_lck_tbl);
1680: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
1681: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
1682: END IF;

Line 1679: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks', l_po_line_s_no_lck_tbl);

1675: AND pel.lock_by_draft_id = plda.draft_id
1676: AND pel.lock_type IN ('F', 'P'));
1677: d_position := 40;
1678: IF (PO_LOG.d_stmt) THEN
1679: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks', l_po_line_s_no_lck_tbl);
1680: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
1681: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
1682: END IF;
1683:

Line 1680: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);

1676: AND pel.lock_type IN ('F', 'P'));
1677: d_position := 40;
1678: IF (PO_LOG.d_stmt) THEN
1679: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks', l_po_line_s_no_lck_tbl);
1680: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
1681: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
1682: END IF;
1683:
1684: -- : Identify po_line_id for S, No and P locks including comlex pricing attr

Line 1681: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);

1677: d_position := 40;
1678: IF (PO_LOG.d_stmt) THEN
1679: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks', l_po_line_s_no_lck_tbl);
1680: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
1681: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
1682: END IF;
1683:
1684: -- : Identify po_line_id for S, No and P locks including comlex pricing attr
1685: SELECT plda.po_line_id

Line 1707: IF (PO_LOG.d_stmt) THEN

1703: WHERE plda.po_line_id = l_po_line_s_no_lck_tbl(i)
1704: AND plda.draft_id=p_draft_id;
1705:
1706: d_position := 50;
1707: IF (PO_LOG.d_stmt) THEN
1708: PO_LOG.stmt(d_module,d_position ,'Deleted po_line_ids for S and No locks',SQL%ROWCOUNT);
1709: END IF;
1710:
1711: -- 4. Copy the delted lines in #3 from the base document

Line 1708: PO_LOG.stmt(d_module,d_position ,'Deleted po_line_ids for S and No locks',SQL%ROWCOUNT);

1704: AND plda.draft_id=p_draft_id;
1705:
1706: d_position := 50;
1707: IF (PO_LOG.d_stmt) THEN
1708: PO_LOG.stmt(d_module,d_position ,'Deleted po_line_ids for S and No locks',SQL%ROWCOUNT);
1709: END IF;
1710:
1711: -- 4. Copy the delted lines in #3 from the base document
1712: PO_LINES_DRAFT_PKG.sync_draft_from_txn

Line 1720: IF (PO_LOG.d_stmt) THEN

1716: x_record_already_exist_tbl => l_record_already_exists
1717: );
1718:
1719: d_position := 50;
1720: IF (PO_LOG.d_stmt) THEN
1721: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');
1722: END IF;
1723:
1724: -- 5. Sync quantity and amount using the values fetched in #1 above

Line 1721: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');

1717: );
1718:
1719: d_position := 50;
1720: IF (PO_LOG.d_stmt) THEN
1721: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');
1722: END IF;
1723:
1724: -- 5. Sync quantity and amount using the values fetched in #1 above
1725: FORALL i in 1.. l_po_line_id_tbl.COUNT

Line 1735: IF (PO_LOG.d_stmt) THEN

1731: WHERE po_line_id = l_po_line_id_tbl(i)
1732: AND draft_id = p_draft_id;
1733:
1734: d_position := 60;
1735: IF (PO_LOG.d_stmt) THEN
1736: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
1737: END IF;
1738:
1739: -- 6. If UDA is enabled, then sync uda attributes

Line 1736: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);

1732: AND draft_id = p_draft_id;
1733:
1734: d_position := 60;
1735: IF (PO_LOG.d_stmt) THEN
1736: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
1737: END IF;
1738:
1739: -- 6. If UDA is enabled, then sync uda attributes
1740: IF p_uda_enabled_flag = 'Y'THEN

Line 1750: IF (PO_LOG.d_stmt) THEN

1746: );
1747: END IF;
1748:
1749: d_position := 70;
1750: IF (PO_LOG.d_stmt) THEN
1751: PO_LOG.stmt(d_module,d_position ,'sync_lines_ext');
1752: END IF;
1753:
1754: -- 7. Sync po_attribute_values_draft

Line 1751: PO_LOG.stmt(d_module,d_position ,'sync_lines_ext');

1747: END IF;
1748:
1749: d_position := 70;
1750: IF (PO_LOG.d_stmt) THEN
1751: PO_LOG.stmt(d_module,d_position ,'sync_lines_ext');
1752: END IF;
1753:
1754: -- 7. Sync po_attribute_values_draft
1755: --delete the recored from po_attribute_values_draft for the given header_id and draft_id

Line 1791: IF (PO_LOG.d_stmt) THEN

1787: WHERE pavd.attribute_values_id=l_attribute_values_id_tbl(i)
1788: AND pavd.draft_id = p_draft_id ;
1789:
1790: d_position := 80;
1791: IF (PO_LOG.d_stmt) THEN
1792: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_DRAFT_PKG.sync_draft_from_txn');
1793: END IF;
1794:
1795: -- 8. Sync po_attribute_values_tlp_draft

Line 1792: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_DRAFT_PKG.sync_draft_from_txn');

1788: AND pavd.draft_id = p_draft_id ;
1789:
1790: d_position := 80;
1791: IF (PO_LOG.d_stmt) THEN
1792: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_DRAFT_PKG.sync_draft_from_txn');
1793: END IF;
1794:
1795: -- 8. Sync po_attribute_values_tlp_draft
1796: --delete the recored from po_attribute_values_tlp_draft for the given header_id and draft_id

Line 1833: IF (PO_LOG.d_stmt) THEN

1829: WHERE pavd.attribute_values_tlp_id=l_attribute_values_tlp_id_tbl(i)
1830: AND pavd.draft_id = p_draft_id ;
1831:
1832: d_position := 90;
1833: IF (PO_LOG.d_stmt) THEN
1834: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_TLP_DRAFT_PKG.sync_draft_from_txn');
1835: END IF;
1836:
1837: -- 9. Sync po_price_differentials

Line 1834: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_TLP_DRAFT_PKG.sync_draft_from_txn');

1830: AND pavd.draft_id = p_draft_id ;
1831:
1832: d_position := 90;
1833: IF (PO_LOG.d_stmt) THEN
1834: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_TLP_DRAFT_PKG.sync_draft_from_txn');
1835: END IF;
1836:
1837: -- 9. Sync po_price_differentials
1838: --delete the recored from po_price_differentials for the given header_id and draft_id

Line 1875: IF (PO_LOG.d_stmt) THEN

1871: WHERE ppdr.price_differential_id=l_price_differential_id_tbl(i)
1872: AND ppdr.draft_id = p_draft_id ;
1873:
1874: d_position := 100;
1875: IF (PO_LOG.d_stmt) THEN
1876: PO_LOG.stmt(d_module,d_position ,'PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn');
1877: END IF;
1878:
1879: FORALL i in 1.. l_po_line_id_tbl.COUNT

Line 1876: PO_LOG.stmt(d_module,d_position ,'PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn');

1872: AND ppdr.draft_id = p_draft_id ;
1873:
1874: d_position := 100;
1875: IF (PO_LOG.d_stmt) THEN
1876: PO_LOG.stmt(d_module,d_position ,'PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn');
1877: END IF;
1878:
1879: FORALL i in 1.. l_po_line_id_tbl.COUNT
1880: UPDATE po_lines_draft_all

Line 1887: IF (PO_LOG.d_stmt) THEN

1883: WHERE po_line_id = l_po_line_id_tbl(i)
1884: AND draft_id = p_draft_id;
1885:
1886: d_position := 110;
1887: IF (PO_LOG.d_stmt) THEN
1888: PO_LOG.stmt(d_module,d_position ,'Number Of Rows Updated',SQL%ROWCOUNT);
1889: END IF;
1890:
1891: -- UCA Project CLM R4 changes BEGIN

Line 1888: PO_LOG.stmt(d_module,d_position ,'Number Of Rows Updated',SQL%ROWCOUNT);

1884: AND draft_id = p_draft_id;
1885:
1886: d_position := 110;
1887: IF (PO_LOG.d_stmt) THEN
1888: PO_LOG.stmt(d_module,d_position ,'Number Of Rows Updated',SQL%ROWCOUNT);
1889: END IF;
1890:
1891: -- UCA Project CLM R4 changes BEGIN
1892: IF l_po_line_id_tbl.COUNT > 0 THEN

Line 1946: IF (PO_LOG.d_proc) THEN

1942: AND order_type_lookup_code in('AMOUNT', 'FIXED PRICE');--bug 16451273
1943: -- UCA Project CLM R4 Changes End
1944:
1945: d_position := 120;
1946: IF (PO_LOG.d_proc) THEN
1947: PO_LOG.proc_end(d_module);
1948: END IF;
1949:
1950: EXCEPTION

Line 1947: PO_LOG.proc_end(d_module);

1943: -- UCA Project CLM R4 Changes End
1944:
1945: d_position := 120;
1946: IF (PO_LOG.d_proc) THEN
1947: PO_LOG.proc_end(d_module);
1948: END IF;
1949:
1950: EXCEPTION
1951: WHEN others THEN

Line 1953: IF (PO_LOG.d_exc) THEN

1949:
1950: EXCEPTION
1951: WHEN others THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: IF (PO_LOG.d_exc) THEN
1954: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1955: END IF;
1956: RAISE;
1957: END sync_lines;

Line 1954: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

1950: EXCEPTION
1951: WHEN others THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: IF (PO_LOG.d_exc) THEN
1954: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1955: END IF;
1956: RAISE;
1957: END sync_lines;
1958:

Line 2021: IF (PO_LOG.d_proc) THEN

2017: l_record_already_exists:=Po_Tbl_Varchar1();
2018: l_header_base_rev_num:=po_tbl_number();
2019: l_change_status_tbl :=PO_TBL_VARCHAR30();
2020: d_position := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2024: END IF;
2025:

Line 2022: PO_LOG.proc_begin(d_module);

2018: l_header_base_rev_num:=po_tbl_number();
2019: l_change_status_tbl :=PO_TBL_VARCHAR30();
2020: d_position := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2024: END IF;
2025:
2026: -- 1. Identify shipments which P, S or no lock which needs to be synced

Line 2023: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

2019: l_change_status_tbl :=PO_TBL_VARCHAR30();
2020: d_position := 0;
2021: IF (PO_LOG.d_proc) THEN
2022: PO_LOG.proc_begin(d_module);
2023: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2024: END IF;
2025:
2026: -- 1. Identify shipments which P, S or no lock which needs to be synced
2027: -- Collect quantity and amount for all such shipments

Line 2062: IF (PO_LOG.d_stmt) THEN

2058: AND pel.lock_type = 'F')
2059: AND pla.shipment_type <> 'PRICE BREAK';
2060:
2061: d_position := 20;
2062: IF (PO_LOG.d_stmt) THEN
2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);

Line 2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);

2059: AND pla.shipment_type <> 'PRICE BREAK';
2060:
2061: d_position := 20;
2062: IF (PO_LOG.d_stmt) THEN
2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);

Line 2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);

2060:
2061: d_position := 20;
2062: IF (PO_LOG.d_stmt) THEN
2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);

Line 2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);

2061: d_position := 20;
2062: IF (PO_LOG.d_stmt) THEN
2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);

Line 2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);

2062: IF (PO_LOG.d_stmt) THEN
2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);

Line 2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);

2063: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);
2071: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');

Line 2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);

2064: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);
2071: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2072: END IF;

Line 2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);

2065: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);
2071: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2072: END IF;
2073:

Line 2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);

2066: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);
2071: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2072: END IF;
2073:
2074: -- 2. Identify shipments with S lock or no lock which needs to be synced

Line 2071: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');

2067: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2068: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2069: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2070: PO_LOG.stmt(d_module,d_position ,'line_location_id', l_line_location_tbl);
2071: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2072: END IF;
2073:
2074: -- 2. Identify shipments with S lock or no lock which needs to be synced
2075: SELECT plda.line_location_id

Line 2095: IF (PO_LOG.d_stmt) THEN

2091: AND pel.lock_type IN ('F','P'))
2092: AND pla.shipment_type <> 'PRICE BREAK';
2093:
2094: d_position := 40;
2095: IF (PO_LOG.d_stmt) THEN
2096: PO_LOG.stmt(d_module,d_position ,'line_location_id for S and No locks', l_po_line_loc_s_no_lck_tbl);
2097: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2098: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2099: END IF;

Line 2096: PO_LOG.stmt(d_module,d_position ,'line_location_id for S and No locks', l_po_line_loc_s_no_lck_tbl);

2092: AND pla.shipment_type <> 'PRICE BREAK';
2093:
2094: d_position := 40;
2095: IF (PO_LOG.d_stmt) THEN
2096: PO_LOG.stmt(d_module,d_position ,'line_location_id for S and No locks', l_po_line_loc_s_no_lck_tbl);
2097: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2098: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2099: END IF;
2100:

Line 2097: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);

2093:
2094: d_position := 40;
2095: IF (PO_LOG.d_stmt) THEN
2096: PO_LOG.stmt(d_module,d_position ,'line_location_id for S and No locks', l_po_line_loc_s_no_lck_tbl);
2097: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2098: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2099: END IF;
2100:
2101: -- 3. Delete shipments identified in #2 above.

Line 2098: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);

2094: d_position := 40;
2095: IF (PO_LOG.d_stmt) THEN
2096: PO_LOG.stmt(d_module,d_position ,'line_location_id for S and No locks', l_po_line_loc_s_no_lck_tbl);
2097: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2098: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2099: END IF;
2100:
2101: -- 3. Delete shipments identified in #2 above.
2102: FORALL i in 1..l_po_line_loc_s_no_lck_tbl.COUNT

Line 2108: IF (PO_LOG.d_stmt) THEN

2104: WHERE plda.line_location_id = l_po_line_loc_s_no_lck_tbl(i)
2105: AND plda.draft_id = p_draft_id;
2106:
2107: d_position := 50;
2108: IF (PO_LOG.d_stmt) THEN
2109: PO_LOG.stmt(d_module,d_position ,'Deleted line_location_ids having S and No locks',SQL%ROWCOUNT);
2110: END IF;
2111:
2112: -- 4. Copy the delted shipments in #3 from the base document

Line 2109: PO_LOG.stmt(d_module,d_position ,'Deleted line_location_ids having S and No locks',SQL%ROWCOUNT);

2105: AND plda.draft_id = p_draft_id;
2106:
2107: d_position := 50;
2108: IF (PO_LOG.d_stmt) THEN
2109: PO_LOG.stmt(d_module,d_position ,'Deleted line_location_ids having S and No locks',SQL%ROWCOUNT);
2110: END IF;
2111:
2112: -- 4. Copy the delted shipments in #3 from the base document
2113: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

Line 2121: IF (PO_LOG.d_stmt) THEN

2117: x_record_already_exist_tbl => l_record_already_exists
2118: );
2119:
2120: d_position := 50;
2121: IF (PO_LOG.d_stmt) THEN
2122: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');
2123: END IF;
2124:
2125: -- 5. Sync quantity and amount using the values fetched in #1 above

Line 2122: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');

2118: );
2119:
2120: d_position := 50;
2121: IF (PO_LOG.d_stmt) THEN
2122: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');
2123: END IF;
2124:
2125: -- 5. Sync quantity and amount using the values fetched in #1 above
2126: FORALL i in 1.. l_line_location_tbl.COUNT

Line 2136: IF (PO_LOG.d_stmt) THEN

2132: WHERE line_location_id = l_line_location_tbl(i)
2133: AND draft_id = p_draft_id;
2134:
2135: d_position := 60;
2136: IF (PO_LOG.d_stmt) THEN
2137: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
2138: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2139: END IF;
2140:

Line 2137: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);

2133: AND draft_id = p_draft_id;
2134:
2135: d_position := 60;
2136: IF (PO_LOG.d_stmt) THEN
2137: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
2138: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2139: END IF;
2140:
2141: -- 6. If UDA is enabled, then sync uda attributes

Line 2138: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);

2134:
2135: d_position := 60;
2136: IF (PO_LOG.d_stmt) THEN
2137: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
2138: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2139: END IF;
2140:
2141: -- 6. If UDA is enabled, then sync uda attributes
2142: IF p_uda_enabled_flag ='Y' THEN

Line 2151: IF (PO_LOG.d_stmt) THEN

2147: );
2148: END IF;
2149:
2150: d_position := 70;
2151: IF (PO_LOG.d_stmt) THEN
2152: PO_LOG.stmt(d_module,d_position ,'sync_shipments_ext');
2153: END IF;
2154:
2155: FORALL i in 1.. l_line_location_tbl.COUNT

Line 2152: PO_LOG.stmt(d_module,d_position ,'sync_shipments_ext');

2148: END IF;
2149:
2150: d_position := 70;
2151: IF (PO_LOG.d_stmt) THEN
2152: PO_LOG.stmt(d_module,d_position ,'sync_shipments_ext');
2153: END IF;
2154:
2155: FORALL i in 1.. l_line_location_tbl.COUNT
2156: UPDATE po_line_locations_draft_all

Line 2163: IF (PO_LOG.d_stmt) THEN

2159: WHERE line_location_id = l_line_location_tbl(i)
2160: AND draft_id = p_draft_id;
2161:
2162: d_position := 80;
2163: IF (PO_LOG.d_stmt) THEN
2164: PO_LOG.stmt(d_module,d_position ,'Number of Rows Updated',SQL%ROWCOUNT);
2165: END IF;
2166:
2167: d_position := 90;

Line 2164: PO_LOG.stmt(d_module,d_position ,'Number of Rows Updated',SQL%ROWCOUNT);

2160: AND draft_id = p_draft_id;
2161:
2162: d_position := 80;
2163: IF (PO_LOG.d_stmt) THEN
2164: PO_LOG.stmt(d_module,d_position ,'Number of Rows Updated',SQL%ROWCOUNT);
2165: END IF;
2166:
2167: d_position := 90;
2168: IF (PO_LOG.d_proc) THEN

Line 2168: IF (PO_LOG.d_proc) THEN

2164: PO_LOG.stmt(d_module,d_position ,'Number of Rows Updated',SQL%ROWCOUNT);
2165: END IF;
2166:
2167: d_position := 90;
2168: IF (PO_LOG.d_proc) THEN
2169: PO_LOG.proc_end(d_module);
2170: END IF;
2171:
2172: EXCEPTION

Line 2169: PO_LOG.proc_end(d_module);

2165: END IF;
2166:
2167: d_position := 90;
2168: IF (PO_LOG.d_proc) THEN
2169: PO_LOG.proc_end(d_module);
2170: END IF;
2171:
2172: EXCEPTION
2173: WHEN others THEN

Line 2175: IF (PO_LOG.d_exc) THEN

2171:
2172: EXCEPTION
2173: WHEN others THEN
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2175: IF (PO_LOG.d_exc) THEN
2176: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
2177: END IF;
2178: RAISE;
2179: END sync_shipments;

Line 2176: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

2172: EXCEPTION
2173: WHEN others THEN
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2175: IF (PO_LOG.d_exc) THEN
2176: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
2177: END IF;
2178: RAISE;
2179: END sync_shipments;
2180:

Line 2242: IF (PO_LOG.d_proc) THEN

2238: l_record_already_exists:=Po_Tbl_Varchar1();
2239: l_header_base_rev_num :=po_tbl_number();
2240: l_change_status_tbl := PO_TBL_VARCHAR30();
2241: d_position := 0;
2242: IF (PO_LOG.d_proc) THEN
2243: PO_LOG.proc_begin(d_module);
2244: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2245: END IF;
2246:

Line 2243: PO_LOG.proc_begin(d_module);

2239: l_header_base_rev_num :=po_tbl_number();
2240: l_change_status_tbl := PO_TBL_VARCHAR30();
2241: d_position := 0;
2242: IF (PO_LOG.d_proc) THEN
2243: PO_LOG.proc_begin(d_module);
2244: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2245: END IF;
2246:
2247: -- 1. Identify dist which P, S or no lock which needs to be synced

Line 2244: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

2240: l_change_status_tbl := PO_TBL_VARCHAR30();
2241: d_position := 0;
2242: IF (PO_LOG.d_proc) THEN
2243: PO_LOG.proc_begin(d_module);
2244: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2245: END IF;
2246:
2247: -- 1. Identify dist which P, S or no lock which needs to be synced
2248: -- Collect quantity and amount for all such dist

Line 2282: IF (PO_LOG.d_stmt) THEN

2278: AND pel.lock_type = 'F')
2279: AND pla.distribution_type <> 'AGREEMENT';
2280:
2281: d_position := 20;
2282: IF (PO_LOG.d_stmt) THEN
2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);

Line 2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);

2279: AND pla.distribution_type <> 'AGREEMENT';
2280:
2281: d_position := 20;
2282: IF (PO_LOG.d_stmt) THEN
2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);

Line 2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);

2280:
2281: d_position := 20;
2282: IF (PO_LOG.d_stmt) THEN
2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);

Line 2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);

2281: d_position := 20;
2282: IF (PO_LOG.d_stmt) THEN
2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);

Line 2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);

2282: IF (PO_LOG.d_stmt) THEN
2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);

Line 2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);

2283: PO_LOG.stmt(d_module,d_position ,'Base Header Revision Num', l_header_base_rev_num);
2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);
2291: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');

Line 2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);

2284: PO_LOG.stmt(d_module,d_position ,'Base Quantity', l_base_quantity_tbl);
2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);
2291: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2292: END IF;

Line 2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);

2285: PO_LOG.stmt(d_module,d_position ,'Base Amount', l_base_amount_tbl);
2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);
2291: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2292: END IF;
2293:

Line 2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);

2286: PO_LOG.stmt(d_module,d_position ,'Draft Qunatity Limit', l_draft_quantity_tbl);
2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);
2291: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2292: END IF;
2293:
2294: -- 2. Identify dist with S lock or no lock which needs to be synced

Line 2291: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');

2287: PO_LOG.stmt(d_module,d_position ,'Draft Old Quantity Limit', l_draft_old_quantity_tbl);
2288: PO_LOG.stmt(d_module,d_position ,'Draft Amount Limit', l_draft_amount_tbl);
2289: PO_LOG.stmt(d_module,d_position ,'Draft Old Amount Limit', l_draft_old_amount_tbl);
2290: PO_LOG.stmt(d_module,d_position ,'po_distribution_id', l_po_distribution_tbl);
2291: PO_LOG.stmt(d_module,d_position ,'the above values computed for all lock types excluding F and excluding shipment type=PRICE BREAK');
2292: END IF;
2293:
2294: -- 2. Identify dist with S lock or no lock which needs to be synced
2295: SELECT plda.po_distribution_id

Line 2315: IF (PO_LOG.d_stmt) THEN

2311: AND pel.lock_type IN ('F','P'))
2312: AND pla.distribution_type <> 'AGREEMENT';
2313:
2314: d_position := 40;
2315: IF (PO_LOG.d_stmt) THEN
2316: PO_LOG.stmt(d_module,d_position ,'po_distribution_id for S and No locks', l_po_dist_s_no_lck_tbl);
2317: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2318: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2319: END IF;

Line 2316: PO_LOG.stmt(d_module,d_position ,'po_distribution_id for S and No locks', l_po_dist_s_no_lck_tbl);

2312: AND pla.distribution_type <> 'AGREEMENT';
2313:
2314: d_position := 40;
2315: IF (PO_LOG.d_stmt) THEN
2316: PO_LOG.stmt(d_module,d_position ,'po_distribution_id for S and No locks', l_po_dist_s_no_lck_tbl);
2317: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2318: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2319: END IF;
2320:

Line 2317: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);

2313:
2314: d_position := 40;
2315: IF (PO_LOG.d_stmt) THEN
2316: PO_LOG.stmt(d_module,d_position ,'po_distribution_id for S and No locks', l_po_dist_s_no_lck_tbl);
2317: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2318: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2319: END IF;
2320:
2321: -- 3. Delete dist identified in #2 above.

Line 2318: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);

2314: d_position := 40;
2315: IF (PO_LOG.d_stmt) THEN
2316: PO_LOG.stmt(d_module,d_position ,'po_distribution_id for S and No locks', l_po_dist_s_no_lck_tbl);
2317: PO_LOG.stmt(d_module,d_position ,'Draft Id Tbl', l_draft_id_tbl);
2318: PO_LOG.stmt(d_module,d_position ,'Delete Flag Tbl', l_delete_flag_tbl);
2319: END IF;
2320:
2321: -- 3. Delete dist identified in #2 above.
2322: FORALL i in 1..l_po_dist_s_no_lck_tbl.COUNT

Line 2328: IF (PO_LOG.d_stmt) THEN

2324: WHERE plda.po_distribution_id=l_po_dist_s_no_lck_tbl(i)
2325: AND plda.draft_id = p_draft_id;
2326:
2327: d_position := 50;
2328: IF (PO_LOG.d_stmt) THEN
2329: PO_LOG.stmt(d_module,d_position ,'Deleted po_dist_ids having S and No locks',SQL%ROWCOUNT);
2330: END IF;
2331:
2332: -- 4. Copy the delted dist in #3 from the base document

Line 2329: PO_LOG.stmt(d_module,d_position ,'Deleted po_dist_ids having S and No locks',SQL%ROWCOUNT);

2325: AND plda.draft_id = p_draft_id;
2326:
2327: d_position := 50;
2328: IF (PO_LOG.d_stmt) THEN
2329: PO_LOG.stmt(d_module,d_position ,'Deleted po_dist_ids having S and No locks',SQL%ROWCOUNT);
2330: END IF;
2331:
2332: -- 4. Copy the delted dist in #3 from the base document
2333: PO_DISTRIBUTIONS_DRAFT_PKG.sync_draft_from_txn

Line 2341: IF (PO_LOG.d_stmt) THEN

2337: x_record_already_exist_tbl => l_record_already_exists
2338: );
2339:
2340: d_position := 50;
2341: IF (PO_LOG.d_stmt) THEN
2342: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');
2343: END IF;
2344:
2345: -- 5. Sync quantity and amount using the values fetched in #1 above

Line 2342: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');

2338: );
2339:
2340: d_position := 50;
2341: IF (PO_LOG.d_stmt) THEN
2342: PO_LOG.stmt(d_module,d_position ,'sync_draft_from_txn');
2343: END IF;
2344:
2345: -- 5. Sync quantity and amount using the values fetched in #1 above
2346: FORALL i in 1.. l_po_distribution_tbl.COUNT

Line 2358: IF (PO_LOG.d_stmt) THEN

2354: WHERE po_distribution_id = l_po_distribution_tbl(i)
2355: AND draft_id = p_draft_id;
2356:
2357: d_position := 60;
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module,d_position ,'update po_distributions_draft_all for all locks excluding F lock');
2360: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2361: END IF;
2362:

Line 2359: PO_LOG.stmt(d_module,d_position ,'update po_distributions_draft_all for all locks excluding F lock');

2355: AND draft_id = p_draft_id;
2356:
2357: d_position := 60;
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module,d_position ,'update po_distributions_draft_all for all locks excluding F lock');
2360: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2361: END IF;
2362:
2363: d_position := 80;

Line 2360: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);

2356:
2357: d_position := 60;
2358: IF (PO_LOG.d_stmt) THEN
2359: PO_LOG.stmt(d_module,d_position ,'update po_distributions_draft_all for all locks excluding F lock');
2360: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2361: END IF;
2362:
2363: d_position := 80;
2364: IF (PO_LOG.d_proc) THEN

Line 2364: IF (PO_LOG.d_proc) THEN

2360: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2361: END IF;
2362:
2363: d_position := 80;
2364: IF (PO_LOG.d_proc) THEN
2365: PO_LOG.proc_end(d_module);
2366: END IF;
2367:
2368: EXCEPTION

Line 2365: PO_LOG.proc_end(d_module);

2361: END IF;
2362:
2363: d_position := 80;
2364: IF (PO_LOG.d_proc) THEN
2365: PO_LOG.proc_end(d_module);
2366: END IF;
2367:
2368: EXCEPTION
2369: WHEN others THEN

Line 2371: IF (PO_LOG.d_exc) THEN

2367:
2368: EXCEPTION
2369: WHEN others THEN
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: IF (PO_LOG.d_exc) THEN
2372: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
2373: END IF;
2374: RAISE;
2375: END sync_distributions;

Line 2372: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

2368: EXCEPTION
2369: WHEN others THEN
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: IF (PO_LOG.d_exc) THEN
2372: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
2373: END IF;
2374: RAISE;
2375: END sync_distributions;
2376:

Line 2413: IF (PO_LOG.d_proc) THEN

2409: d_api_version CONSTANT NUMBER := 1.0;
2410: BEGIN
2411:
2412: d_position := 0;
2413: IF (PO_LOG.d_proc) THEN
2414: PO_LOG.proc_begin(d_module);
2415: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2416: END IF;
2417:

Line 2414: PO_LOG.proc_begin(d_module);

2410: BEGIN
2411:
2412: d_position := 0;
2413: IF (PO_LOG.d_proc) THEN
2414: PO_LOG.proc_begin(d_module);
2415: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2416: END IF;
2417:
2418: l_entension_id_tbl:=po_tbl_number();

Line 2415: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

2411:
2412: d_position := 0;
2413: IF (PO_LOG.d_proc) THEN
2414: PO_LOG.proc_begin(d_module);
2415: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
2416: END IF;
2417:
2418: l_entension_id_tbl:=po_tbl_number();
2419: SELECT document_id

Line 2425: IF (PO_LOG.d_stmt) THEN

2421: FROM po_drafts
2422: WHERE draft_id = p_draft_id;
2423:
2424: d_position := 20;
2425: IF (PO_LOG.d_stmt) THEN
2426: PO_LOG.stmt(d_module,d_position ,'PODraft Header Id', l_po_header_id);
2427: END IF;
2428:
2429: MERGE

Line 2426: PO_LOG.stmt(d_module,d_position ,'PODraft Header Id', l_po_header_id);

2422: WHERE draft_id = p_draft_id;
2423:
2424: d_position := 20;
2425: IF (PO_LOG.d_stmt) THEN
2426: PO_LOG.stmt(d_module,d_position ,'PODraft Header Id', l_po_header_id);
2427: END IF;
2428:
2429: MERGE
2430: INTO po_headers_all_ext_b phbd

Line 2880: IF (PO_LOG.d_stmt) THEN

2876: phb.revision_num );
2877:
2878:
2879: d_position := 30;
2880: IF (PO_LOG.d_stmt) THEN
2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:

Line 2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');

2877:
2878:
2879: d_position := 30;
2880: IF (PO_LOG.d_stmt) THEN
2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:
2885: -- Update multi Row header Ext n rev num

Line 2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

2878:
2879: d_position := 30;
2880: IF (PO_LOG.d_stmt) THEN
2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:
2885: -- Update multi Row header Ext n rev num
2886: DELETE FROM po_headers_all_ext_b pheb

Line 2902: IF (PO_LOG.d_stmt) THEN

2898: FROM ego_fnd_dsc_flx_ctx_ext ag
2899: WHERE pheb.attr_group_id = ag.attr_group_id
2900: AND ag.multi_row = 'Y');
2901: d_position := 40;
2902: IF (PO_LOG.d_stmt) THEN
2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2904: END IF;
2905:
2906: INSERT INTO po_headers_all_ext_b phbd

Line 2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');

2899: WHERE pheb.attr_group_id = ag.attr_group_id
2900: AND ag.multi_row = 'Y');
2901: d_position := 40;
2902: IF (PO_LOG.d_stmt) THEN
2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2904: END IF;
2905:
2906: INSERT INTO po_headers_all_ext_b phbd
2907: ( phbd.extension_id ,

Line 3139: IF (PO_LOG.d_stmt) THEN

3135: WHERE phb.attr_group_id = ag.attr_group_id
3136: AND ag.multi_row = 'Y');
3137:
3138: d_position :=60;
3139: IF (PO_LOG.d_stmt) THEN
3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');
3141: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3142: END IF;
3143:

Line 3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');

3136: AND ag.multi_row = 'Y');
3137:
3138: d_position :=60;
3139: IF (PO_LOG.d_stmt) THEN
3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');
3141: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3142: END IF;
3143:
3144:

Line 3141: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

3137:
3138: d_position :=60;
3139: IF (PO_LOG.d_stmt) THEN
3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');
3141: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3142: END IF;
3143:
3144:
3145: SELECT b.extension_id

Line 3226: IF (PO_LOG.d_stmt) THEN

3222: AND l.installed_flag IN ('B', 'I')
3223: ;
3224:
3225: d_position :=70;
3226: IF (PO_LOG.d_stmt) THEN
3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');
3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3229: END IF;
3230:

Line 3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');

3223: ;
3224:
3225: d_position :=70;
3226: IF (PO_LOG.d_stmt) THEN
3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');
3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3229: END IF;
3230:
3231: d_position := 80;

Line 3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

3224:
3225: d_position :=70;
3226: IF (PO_LOG.d_stmt) THEN
3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');
3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3229: END IF;
3230:
3231: d_position := 80;
3232: IF (PO_LOG.d_proc) THEN

Line 3232: IF (PO_LOG.d_proc) THEN

3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3229: END IF;
3230:
3231: d_position := 80;
3232: IF (PO_LOG.d_proc) THEN
3233: PO_LOG.proc_end(d_module);
3234: END IF;
3235:
3236: EXCEPTION

Line 3233: PO_LOG.proc_end(d_module);

3229: END IF;
3230:
3231: d_position := 80;
3232: IF (PO_LOG.d_proc) THEN
3233: PO_LOG.proc_end(d_module);
3234: END IF;
3235:
3236: EXCEPTION
3237: WHEN others THEN

Line 3239: IF (PO_LOG.d_exc) THEN

3235:
3236: EXCEPTION
3237: WHEN others THEN
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3239: IF (PO_LOG.d_exc) THEN
3240: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
3241: END IF;
3242: RAISE;
3243: END sync_headers_ext;

Line 3240: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

3236: EXCEPTION
3237: WHEN others THEN
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3239: IF (PO_LOG.d_exc) THEN
3240: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
3241: END IF;
3242: RAISE;
3243: END sync_headers_ext;
3244:

Line 3283: IF (PO_LOG.d_proc) THEN

3279: -- : Will use p_po_line_s_no_lck_tbl instead of l_po_line_s_no_lck_tbl
3280: --Also replace l_po_line_s_no_p_lck_tbl with p_po_line_s_no_p_lck_tbl
3281:
3282: d_position := 0;
3283: IF (PO_LOG.d_proc) THEN
3284: PO_LOG.proc_begin(d_module);
3285: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
3286: END IF;
3287:

Line 3284: PO_LOG.proc_begin(d_module);

3280: --Also replace l_po_line_s_no_p_lck_tbl with p_po_line_s_no_p_lck_tbl
3281:
3282: d_position := 0;
3283: IF (PO_LOG.d_proc) THEN
3284: PO_LOG.proc_begin(d_module);
3285: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
3286: END IF;
3287:
3288: -- : Cleaning up. p_po_line_s_no_lck_tbl already passed as param to api

Line 3285: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

3281:
3282: d_position := 0;
3283: IF (PO_LOG.d_proc) THEN
3284: PO_LOG.proc_begin(d_module);
3285: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
3286: END IF;
3287:
3288: -- : Cleaning up. p_po_line_s_no_lck_tbl already passed as param to api
3289:

Line 3291: IF (PO_LOG.d_stmt) THEN

3287:
3288: -- : Cleaning up. p_po_line_s_no_lck_tbl already passed as param to api
3289:
3290: d_position := 20;
3291: IF (PO_LOG.d_stmt) THEN
3292: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks excluding comlex pricing attr', p_po_line_s_no_lck_tbl);
3293: END IF;
3294:
3295: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT

Line 3292: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks excluding comlex pricing attr', p_po_line_s_no_lck_tbl);

3288: -- : Cleaning up. p_po_line_s_no_lck_tbl already passed as param to api
3289:
3290: d_position := 20;
3291: IF (PO_LOG.d_stmt) THEN
3292: PO_LOG.stmt(d_module,d_position ,'po_line_id for S and No locks excluding comlex pricing attr', p_po_line_s_no_lck_tbl);
3293: END IF;
3294:
3295: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT
3296: UPDATE po_lines_all_ext_b plbd

Line 3496: IF (PO_LOG.d_stmt) THEN

3492: AND puatu.attribute_group_id = plbd.attr_group_id
3493: );
3494:
3495: d_position := 40;
3496: IF (PO_LOG.d_stmt) THEN
3497: PO_LOG.stmt(d_module,d_position ,'Updated po_lines_all_ext_b for S and No locks');
3498: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3499: END IF;
3500:

Line 3497: PO_LOG.stmt(d_module,d_position ,'Updated po_lines_all_ext_b for S and No locks');

3493: );
3494:
3495: d_position := 40;
3496: IF (PO_LOG.d_stmt) THEN
3497: PO_LOG.stmt(d_module,d_position ,'Updated po_lines_all_ext_b for S and No locks');
3498: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3499: END IF;
3500:
3501: -- : Cleaning up. p_po_line_s_no_p_lck_tblalready passed as param to this api.

Line 3498: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

3494:
3495: d_position := 40;
3496: IF (PO_LOG.d_stmt) THEN
3497: PO_LOG.stmt(d_module,d_position ,'Updated po_lines_all_ext_b for S and No locks');
3498: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3499: END IF;
3500:
3501: -- : Cleaning up. p_po_line_s_no_p_lck_tblalready passed as param to this api.
3502:

Line 3504: IF (PO_LOG.d_stmt) THEN

3500:
3501: -- : Cleaning up. p_po_line_s_no_p_lck_tblalready passed as param to this api.
3502:
3503: d_position := 40;
3504: IF (PO_LOG.d_stmt) THEN
3505: PO_LOG.stmt(d_module,d_position ,'po_line_id for S, No and P locks including comlex pricing attr', p_po_line_s_no_p_lck_tbl);
3506: END IF;
3507:
3508: -- We need 3 update statement

Line 3505: PO_LOG.stmt(d_module,d_position ,'po_line_id for S, No and P locks including comlex pricing attr', p_po_line_s_no_p_lck_tbl);

3501: -- : Cleaning up. p_po_line_s_no_p_lck_tblalready passed as param to this api.
3502:
3503: d_position := 40;
3504: IF (PO_LOG.d_stmt) THEN
3505: PO_LOG.stmt(d_module,d_position ,'po_line_id for S, No and P locks including comlex pricing attr', p_po_line_s_no_p_lck_tbl);
3506: END IF;
3507:
3508: -- We need 3 update statement
3509: -- 1st update old value records for S lock, P lock and no lock lines

Line 3712: IF (PO_LOG.d_stmt) THEN

3708: AND puatu.attribute_group_id = plbd.attr_group_id
3709: );
3710:
3711: d_position := 60;
3712: IF (PO_LOG.d_stmt) THEN
3713: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to Old MOdification');
3714: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3715: END IF;
3716:

Line 3713: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to Old MOdification');

3709: );
3710:
3711: d_position := 60;
3712: IF (PO_LOG.d_stmt) THEN
3713: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to Old MOdification');
3714: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3715: END IF;
3716:
3717: --2nd update all attributes excluding numeric attributes for S or no lock lines

Line 3714: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

3710:
3711: d_position := 60;
3712: IF (PO_LOG.d_stmt) THEN
3713: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to Old MOdification');
3714: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3715: END IF;
3716:
3717: --2nd update all attributes excluding numeric attributes for S or no lock lines
3718: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT

Line 3880: IF (PO_LOG.d_stmt) THEN

3876: AND puatu.attribute_group_id = plbd.attr_group_id
3877: );
3878:
3879: d_position := 70;
3880: IF (PO_LOG.d_stmt) THEN
3881: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification Excluding Numeric attributes');
3882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3883: END IF;
3884:

Line 3881: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification Excluding Numeric attributes');

3877: );
3878:
3879: d_position := 70;
3880: IF (PO_LOG.d_stmt) THEN
3881: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification Excluding Numeric attributes');
3882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3883: END IF;
3884:
3885: ---3rd update numeric attributes.. for s, p, null lock types

Line 3882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

3878:
3879: d_position := 70;
3880: IF (PO_LOG.d_stmt) THEN
3881: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification Excluding Numeric attributes');
3882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3883: END IF;
3884:
3885: ---3rd update numeric attributes.. for s, p, null lock types
3886: FORALL i in 1..p_po_line_s_no_p_lck_tbl.COUNT

Line 3953: IF (PO_LOG.d_stmt) THEN

3949: AND puatu.attribute_group_id = plbd.attr_group_id
3950: );
3951:
3952: d_position := 80;
3953: IF (PO_LOG.d_stmt) THEN
3954: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification only for Numeric attributes');
3955: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3956: END IF;
3957:

Line 3954: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification only for Numeric attributes');

3950: );
3951:
3952: d_position := 80;
3953: IF (PO_LOG.d_stmt) THEN
3954: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification only for Numeric attributes');
3955: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3956: END IF;
3957:
3958: -- Update lines in ext_tl table

Line 3955: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

3951:
3952: d_position := 80;
3953: IF (PO_LOG.d_stmt) THEN
3954: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_b corresponding to New MOdification only for Numeric attributes');
3955: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3956: END IF;
3957:
3958: -- Update lines in ext_tl table
3959: FORALL i in 1..p_po_line_s_no_lck_tbl.COUNT

Line 4055: IF (PO_LOG.d_stmt) THEN

4051: AND pltd.PK1_VALUE is null;
4052:
4053:
4054: d_position := 90;
4055: IF (PO_LOG.d_stmt) THEN
4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');
4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;

Line 4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');

4052:
4053:
4054: d_position := 90;
4055: IF (PO_LOG.d_stmt) THEN
4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');
4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;
4060: IF (PO_LOG.d_proc) THEN

Line 4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

4053:
4054: d_position := 90;
4055: IF (PO_LOG.d_stmt) THEN
4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');
4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;
4060: IF (PO_LOG.d_proc) THEN
4061: PO_LOG.proc_end(d_module);

Line 4060: IF (PO_LOG.d_proc) THEN

4056: PO_LOG.stmt(d_module,d_position ,'updated po_lines_all_ext_tl ');
4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;
4060: IF (PO_LOG.d_proc) THEN
4061: PO_LOG.proc_end(d_module);
4062: END IF;
4063:
4064: EXCEPTION

Line 4061: PO_LOG.proc_end(d_module);

4057: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4058: END IF;
4059: d_position := 100;
4060: IF (PO_LOG.d_proc) THEN
4061: PO_LOG.proc_end(d_module);
4062: END IF;
4063:
4064: EXCEPTION
4065: WHEN others THEN

Line 4067: IF (PO_LOG.d_exc) THEN

4063:
4064: EXCEPTION
4065: WHEN others THEN
4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067: IF (PO_LOG.d_exc) THEN
4068: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4069: END IF;
4070: RAISE;
4071: END sync_lines_ext;

Line 4068: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

4064: EXCEPTION
4065: WHEN others THEN
4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067: IF (PO_LOG.d_exc) THEN
4068: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4069: END IF;
4070: RAISE;
4071: END sync_lines_ext;
4072:

Line 4107: IF (PO_LOG.d_proc) THEN

4103: BEGIN
4104: -- : Will use p_po_line_loc_s_no_lck_tbl instead of l_po_line_loc_s_no_lck_tbl
4105:
4106: d_position := 0;
4107: IF (PO_LOG.d_proc) THEN
4108: PO_LOG.proc_begin(d_module);
4109: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
4110: END IF;
4111:

Line 4108: PO_LOG.proc_begin(d_module);

4104: -- : Will use p_po_line_loc_s_no_lck_tbl instead of l_po_line_loc_s_no_lck_tbl
4105:
4106: d_position := 0;
4107: IF (PO_LOG.d_proc) THEN
4108: PO_LOG.proc_begin(d_module);
4109: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
4110: END IF;
4111:
4112: -- : Cleaning up. p_po_line_loc_s_no_lck_tbl is already passed as parameter to this api

Line 4109: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

4105:
4106: d_position := 0;
4107: IF (PO_LOG.d_proc) THEN
4108: PO_LOG.proc_begin(d_module);
4109: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
4110: END IF;
4111:
4112: -- : Cleaning up. p_po_line_loc_s_no_lck_tbl is already passed as parameter to this api
4113:

Line 4115: IF (PO_LOG.d_stmt) THEN

4111:
4112: -- : Cleaning up. p_po_line_loc_s_no_lck_tbl is already passed as parameter to this api
4113:
4114: d_position := 20;
4115: IF (PO_LOG.d_stmt) THEN
4116: PO_LOG.stmt(d_module,d_position ,'line_loc_id for S and No locks excluding Price break', p_po_line_loc_s_no_lck_tbl);
4117: END IF;
4118:
4119: FORALL i in 1..p_po_line_loc_s_no_lck_tbl.COUNT

Line 4116: PO_LOG.stmt(d_module,d_position ,'line_loc_id for S and No locks excluding Price break', p_po_line_loc_s_no_lck_tbl);

4112: -- : Cleaning up. p_po_line_loc_s_no_lck_tbl is already passed as parameter to this api
4113:
4114: d_position := 20;
4115: IF (PO_LOG.d_stmt) THEN
4116: PO_LOG.stmt(d_module,d_position ,'line_loc_id for S and No locks excluding Price break', p_po_line_loc_s_no_lck_tbl);
4117: END IF;
4118:
4119: FORALL i in 1..p_po_line_loc_s_no_lck_tbl.COUNT
4120: UPDATE po_line_locations_all_ext_b plld

Line 4311: IF (PO_LOG.d_stmt) THEN

4307: WHERE plld.line_location_id = p_po_line_loc_s_no_lck_tbl(i)
4308: AND plld.draft_id = p_draft_id;
4309:
4310: d_position := 50;
4311: IF (PO_LOG.d_stmt) THEN
4312: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_b for the given p_drat_id');
4313: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4314: END IF;
4315:

Line 4312: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_b for the given p_drat_id');

4308: AND plld.draft_id = p_draft_id;
4309:
4310: d_position := 50;
4311: IF (PO_LOG.d_stmt) THEN
4312: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_b for the given p_drat_id');
4313: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4314: END IF;
4315:
4316: --update for tl tables

Line 4313: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

4309:
4310: d_position := 50;
4311: IF (PO_LOG.d_stmt) THEN
4312: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_b for the given p_drat_id');
4313: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4314: END IF;
4315:
4316: --update for tl tables
4317: FORALL i in 1..p_po_line_loc_s_no_lck_tbl.COUNT

Line 4410: IF (PO_LOG.d_stmt) THEN

4406: WHERE plltd.line_location_id = p_po_line_loc_s_no_lck_tbl(i)
4407: AND plltd.draft_id = p_draft_id;
4408:
4409: d_position := 70;
4410: IF (PO_LOG.d_stmt) THEN
4411: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_tl for the given p_drat_id');
4412: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4413: END IF;
4414:

Line 4411: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_tl for the given p_drat_id');

4407: AND plltd.draft_id = p_draft_id;
4408:
4409: d_position := 70;
4410: IF (PO_LOG.d_stmt) THEN
4411: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_tl for the given p_drat_id');
4412: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4413: END IF;
4414:
4415: d_position := 100;

Line 4412: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

4408:
4409: d_position := 70;
4410: IF (PO_LOG.d_stmt) THEN
4411: PO_LOG.stmt(d_module,d_position ,'Updated po_line_locations_all_ext_tl for the given p_drat_id');
4412: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4413: END IF;
4414:
4415: d_position := 100;
4416: IF (PO_LOG.d_proc) THEN

Line 4416: IF (PO_LOG.d_proc) THEN

4412: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4413: END IF;
4414:
4415: d_position := 100;
4416: IF (PO_LOG.d_proc) THEN
4417: PO_LOG.proc_end(d_module);
4418: END IF;
4419:
4420: EXCEPTION

Line 4417: PO_LOG.proc_end(d_module);

4413: END IF;
4414:
4415: d_position := 100;
4416: IF (PO_LOG.d_proc) THEN
4417: PO_LOG.proc_end(d_module);
4418: END IF;
4419:
4420: EXCEPTION
4421: WHEN others THEN

Line 4423: IF (PO_LOG.d_exc) THEN

4419:
4420: EXCEPTION
4421: WHEN others THEN
4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4423: IF (PO_LOG.d_exc) THEN
4424: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4425: END IF;
4426: RAISE;
4427: END sync_shipments_ext;

Line 4424: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

4420: EXCEPTION
4421: WHEN others THEN
4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4423: IF (PO_LOG.d_exc) THEN
4424: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4425: END IF;
4426: RAISE;
4427: END sync_shipments_ext;
4428:

Line 4462: IF (PO_LOG.d_proc) THEN

4458: d_api_version CONSTANT NUMBER := 1.0;
4459: BEGIN
4460:
4461: d_position := 0;
4462: IF (PO_LOG.d_proc) THEN
4463: PO_LOG.proc_begin(d_module);
4464: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
4465: END IF;
4466:

Line 4463: PO_LOG.proc_begin(d_module);

4459: BEGIN
4460:
4461: d_position := 0;
4462: IF (PO_LOG.d_proc) THEN
4463: PO_LOG.proc_begin(d_module);
4464: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
4465: END IF;
4466:
4467: SELECT document_id

Line 4464: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

4460:
4461: d_position := 0;
4462: IF (PO_LOG.d_proc) THEN
4463: PO_LOG.proc_begin(d_module);
4464: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
4465: END IF;
4466:
4467: SELECT document_id
4468: INTO l_po_header_id

Line 4473: IF (PO_LOG.d_stmt) THEN

4469: FROM po_drafts
4470: WHERE draft_id = p_draft_id;
4471:
4472: d_position := 20;
4473: IF (PO_LOG.d_stmt) THEN
4474: PO_LOG.stmt(d_module,d_position ,'Header Id', l_po_header_id);
4475: END IF;
4476:
4477: UPDATE po_headers_all_ext_b phbd

Line 4474: PO_LOG.stmt(d_module,d_position ,'Header Id', l_po_header_id);

4470: WHERE draft_id = p_draft_id;
4471:
4472: d_position := 20;
4473: IF (PO_LOG.d_stmt) THEN
4474: PO_LOG.stmt(d_module,d_position ,'Header Id', l_po_header_id);
4475: END IF;
4476:
4477: UPDATE po_headers_all_ext_b phbd
4478: SET ( phbd.c_ext_attr1,

Line 4694: IF (PO_LOG.d_stmt) THEN

4690: and phbd.draft_id = dft.draft_id);
4691: -- End AND phd.revision_num>phbd.revision_num
4692:
4693: d_position := 20;
4694: IF (PO_LOG.d_stmt) THEN
4695: PO_LOG.stmt(d_module,d_position ,'Updated UDA_ADDRESS');
4696: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4697: END IF;
4698:

Line 4695: PO_LOG.stmt(d_module,d_position ,'Updated UDA_ADDRESS');

4691: -- End AND phd.revision_num>phbd.revision_num
4692:
4693: d_position := 20;
4694: IF (PO_LOG.d_stmt) THEN
4695: PO_LOG.stmt(d_module,d_position ,'Updated UDA_ADDRESS');
4696: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4697: END IF;
4698:
4699: d_position:=40;

Line 4696: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);

4692:
4693: d_position := 20;
4694: IF (PO_LOG.d_stmt) THEN
4695: PO_LOG.stmt(d_module,d_position ,'Updated UDA_ADDRESS');
4696: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4697: END IF;
4698:
4699: d_position:=40;
4700: IF (PO_LOG.d_proc) THEN

Line 4700: IF (PO_LOG.d_proc) THEN

4696: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
4697: END IF;
4698:
4699: d_position:=40;
4700: IF (PO_LOG.d_proc) THEN
4701: PO_LOG.proc_end(d_module);
4702: END IF;
4703:
4704: EXCEPTION

Line 4701: PO_LOG.proc_end(d_module);

4697: END IF;
4698:
4699: d_position:=40;
4700: IF (PO_LOG.d_proc) THEN
4701: PO_LOG.proc_end(d_module);
4702: END IF;
4703:
4704: EXCEPTION
4705: WHEN OTHERS THEN

Line 4706: IF (PO_LOG.d_exc) THEN

4702: END IF;
4703:
4704: EXCEPTION
4705: WHEN OTHERS THEN
4706: IF (PO_LOG.d_exc) THEN
4707: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4708: END IF;
4709: RAISE;
4710:

Line 4707: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);

4703:
4704: EXCEPTION
4705: WHEN OTHERS THEN
4706: IF (PO_LOG.d_exc) THEN
4707: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4708: END IF;
4709: RAISE;
4710:
4711: END sync_uda_address;