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.CTO_TRANSFER_PRICE_PK dependencies on CTO_WIP_WORKFLOW_API_PK

Line 434: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'entering');

430: fetch get_oeval_org_id into l_oeval_org_id;
431: close get_oeval_org_id;
432:
433: If PG_DEBUG <> 0 Then
434: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'entering');
435: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_grp_id::'||to_char(p_grp_id));
436: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_line_id::'||to_char(p_line_id));
437: End if;
438: IF PG_DEBUG <> 0 THEN

Line 435: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_grp_id::'||to_char(p_grp_id));

431: close get_oeval_org_id;
432:
433: If PG_DEBUG <> 0 Then
434: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'entering');
435: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_grp_id::'||to_char(p_grp_id));
436: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_line_id::'||to_char(p_line_id));
437: End if;
438: IF PG_DEBUG <> 0 THEN
439: oe_debug_pub.add('get_config_details_bcol:entering');

Line 436: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_line_id::'||to_char(p_line_id));

432:
433: If PG_DEBUG <> 0 Then
434: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'entering');
435: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_grp_id::'||to_char(p_grp_id));
436: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', 'p_line_id::'||to_char(p_line_id));
437: End if;
438: IF PG_DEBUG <> 0 THEN
439: oe_debug_pub.add('get_config_details_bcol:entering');
440: oe_debug_pub.add('get_config_details_bcol:p_grp_id::'||to_char(p_grp_id));

Line 573: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);

569: rowcount := SQL%ROWCOUNT;
570:
571: IF PG_DEBUG <> 0 THEN
572: oe_debug_pub.add ('get_config_details_bcol:Row Count : ' || rowcount, 2);
573: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
574:
575: END IF;
576:
577: END LOOP;

Line 668: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);

664: rowcount := SQL%ROWCOUNT;
665:
666: IF PG_DEBUG <> 0 THEN
667: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);
668: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
669:
670: END IF;
671:
672: END LOOP;

Line 679: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', '

675:
676: lStmtNumber := 40;
677: IF PG_DEBUG <> 0 THEN
678: oe_debug_pub.add('get_config_details_bcol:rows inserted into bom_expl_temp::'||to_char(sql%rowcount));
679: cto_wip_workflow_api_pk.cto_debug('get_config_details_bcol:', '
680: rows inserted into bom_expl_temp::'||to_char(sql%rowcount));
681:
682: END IF;
683:

Line 750: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','entering');

746: lStmtNumber := 10;
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748:
749: IF PG_DEBUG <> 0 THEN
750: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','entering');
751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));
752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));
753:
754: oe_debug_pub.add('get_config_details_bom:entering');

Line 751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));

747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748:
749: IF PG_DEBUG <> 0 THEN
750: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','entering');
751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));
752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));
753:
754: oe_debug_pub.add('get_config_details_bom:entering');
755: oe_debug_pub.add('get_config_details_bom:p_grp_id::'||to_char(p_grp_id));

Line 752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));

748:
749: IF PG_DEBUG <> 0 THEN
750: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','entering');
751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));
752: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_item_id::'||to_char(p_item_id));
753:
754: oe_debug_pub.add('get_config_details_bom:entering');
755: oe_debug_pub.add('get_config_details_bom:p_grp_id::'||to_char(p_grp_id));
756: oe_debug_pub.add('get_config_details_bom:p_item_id::'||to_char(p_item_id));

Line 807: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'rowcount::'||sql%rowcount);

803:
804:
805: IF PG_DEBUG <> 0 THEN
806: oe_debug_pub.add('get_config_details_bom:rowcount::'||sql%rowcount);
807: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'rowcount::'||sql%rowcount);
808:
809: END IF;
810:
811: lStmtNumber := 30;

Line 876: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);

872: rowcount := SQL%ROWCOUNT;
873:
874: IF PG_DEBUG <> 0 THEN
875: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);
876: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
877:
878: END IF;
879:
880: END LOOP;

Line 930: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'rowcount::'||sql%rowcount);

926: and msi.base_item_id is not null;
927:
928: IF PG_DEBUG <> 0 THEN
929: oe_debug_pub.add('get_config_details_bom:rowcount::'||sql%rowcount);
930: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'rowcount::'||sql%rowcount);
931:
932: END IF;
933:
934: lStmtNumber := 50;

Line 994: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);

990: rowcount := SQL%ROWCOUNT;
991:
992: IF PG_DEBUG <> 0 THEN
993: oe_debug_pub.add ('get_config_details_bom:Row Count : ' || rowcount, 2);
994: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:', 'Row Count:'||rowcount);
995:
996: END IF;
997:
998: END LOOP;

Line 1100: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Entering');

1096: and assembly_item_id = l_item_id;
1097:
1098: BEGIN
1099: If PG_DEBUG <> 0 Then
1100: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Entering');
1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));
1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));
1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));
1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));

Line 1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));

1097:
1098: BEGIN
1099: If PG_DEBUG <> 0 Then
1100: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Entering');
1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));
1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));
1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));
1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));
1105: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_from_organization_id::'||to_char(p_from_organization_id));

Line 1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));

1098: BEGIN
1099: If PG_DEBUG <> 0 Then
1100: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Entering');
1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));
1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));
1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));
1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));
1105: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_from_organization_id::'||to_char(p_from_organization_id));
1106: End if;

Line 1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));

1099: If PG_DEBUG <> 0 Then
1100: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Entering');
1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));
1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));
1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));
1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));
1105: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_from_organization_id::'||to_char(p_from_organization_id));
1106: End if;
1107:

Line 1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));

1100: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Entering');
1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));
1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));
1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));
1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));
1105: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_from_organization_id::'||to_char(p_from_organization_id));
1106: End if;
1107:
1108: --

Line 1105: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_from_organization_id::'||to_char(p_from_organization_id));

1101: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_config_item_id::'||to_char(p_config_item_id));
1102: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'l_current_item_id::'||to_char(l_current_item_id));
1103: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_selling_oper_unit::'||to_char(p_selling_oper_unit));
1104: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_shipping_oper_unit::'||to_char(p_shipping_oper_unit));
1105: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'p_from_organization_id::'||to_char(p_from_organization_id));
1106: End if;
1107:
1108: --
1109: -- validate config

Line 1128: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'base_item_id::'||l_base_item_id);

1124: from mtl_system_items
1125: where inventory_item_id = p_config_item_id
1126: and organization_id = p_from_organization_id; -- org to create the AR
1127: If PG_DEBUG <> 0 Then
1128: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'base_item_id::'||l_base_item_id);
1129: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'build_in_wip_flag::'||l_build_in_wip);
1130: End if;
1131:
1132: IF ((l_base_item_id IS NULL) OR (l_build_in_wip <> 'Y')) THEN

Line 1129: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'build_in_wip_flag::'||l_build_in_wip);

1125: where inventory_item_id = p_config_item_id
1126: and organization_id = p_from_organization_id; -- org to create the AR
1127: If PG_DEBUG <> 0 Then
1128: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'base_item_id::'||l_base_item_id);
1129: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'build_in_wip_flag::'||l_build_in_wip);
1130: End if;
1131:
1132: IF ((l_base_item_id IS NULL) OR (l_build_in_wip <> 'Y')) THEN
1133: x_transfer_price := null;

Line 1135: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'ERROR::Config item passed by INV is not valid');

1131:
1132: IF ((l_base_item_id IS NULL) OR (l_build_in_wip <> 'Y')) THEN
1133: x_transfer_price := null;
1134: If PG_DEBUG <> 0 Then
1135: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'ERROR::Config item passed by INV is not valid');
1136: End if;
1137:
1138: raise FND_API.G_EXC_ERROR;
1139: END IF;

Line 1155: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'x_group_id::'||to_char(x_group_id));

1151: x_msg_data => x_msg_data,
1152: x_return_status => x_return_status);
1153:
1154: If PG_DEBUG <> 0 Then
1155: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'x_group_id::'||to_char(x_group_id));
1156: End if;
1157:
1158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1159: If PG_DEBUG <> 0 Then

Line 1160: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_config_details:'||sqlerrm);

1156: End if;
1157:
1158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1159: If PG_DEBUG <> 0 Then
1160: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_config_details:'||sqlerrm);
1161: End if;
1162: raise FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: If PG_DEBUG <> 0 Then

Line 1165: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_config_details:'||sqlerrm);

1161: End if;
1162: raise FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: If PG_DEBUG <> 0 Then
1165: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_config_details:'||sqlerrm);
1166: End if;
1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:

Line 1177: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'comp being processed::'||to_char(v_options.component_item_id));

1173: -- If option is lower level config, use config item's
1174: -- price instead of rolling up its components
1175: --
1176: If PG_DEBUG <> 0 Then
1177: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'comp being processed::'||to_char(v_options.component_item_id));
1178: End if;
1179:
1180: IF v_options.configurator_flag = 'Y' THEN
1181:

Line 1183: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'comp being processed is a config item');

1179:
1180: IF v_options.configurator_flag = 'Y' THEN
1181:
1182: If PG_DEBUG <> 0 Then
1183: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'comp being processed is a config item');
1184: End if;
1185:
1186: INV_TRANSACTION_FLOW_PUB.get_transfer_price_for_item
1187: (

Line 1207: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);

1203: );
1204:
1205: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: If PG_DEBUG <> 0 Then
1207: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1208: End if;
1209: raise FND_API.G_EXC_ERROR;
1210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: If PG_DEBUG <> 0 Then

Line 1212: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);

1208: End if;
1209: raise FND_API.G_EXC_ERROR;
1210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: If PG_DEBUG <> 0 Then
1212: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1213: End if;
1214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216: If PG_DEBUG <> 0 Then

Line 1217: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Transfer price of comp '||to_char(v_options.component_item_id)||' is '||to_char(l_transfer_price));

1213: End if;
1214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216: If PG_DEBUG <> 0 Then
1217: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Transfer price of comp '||to_char(v_options.component_item_id)||' is '||to_char(l_transfer_price));
1218: End if;
1219:
1220: IF l_transfer_price <> 0 THEN
1221: x_transfer_price := x_transfer_price + l_transfer_price * v_options.component_quantity;

Line 1267: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);

1263: );
1264:
1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: If PG_DEBUG <> 0 Then
1267: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1268: End if;
1269: raise FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: If PG_DEBUG <> 0 Then

Line 1272: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);

1268: End if;
1269: raise FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: If PG_DEBUG <> 0 Then
1272: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1273: End if;
1274: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:

Line 1278: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Transfer price of comp '||to_char(v_options.component_item_id)||' is '||to_char(l_transfer_price));

1274: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:
1277: If PG_DEBUG <> 0 Then
1278: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Transfer price of comp '||to_char(v_options.component_item_id)||' is '||to_char(l_transfer_price));
1279: End if;
1280: x_transfer_price := x_transfer_price + l_transfer_price * v_options.component_quantity;
1281:
1282: END IF; /* if config item */

Line 1292: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Total Transfer price of item is '||to_char(x_transfer_price));

1288: quantity => 1,
1289: item_id => p_config_item_id);
1290:
1291: If PG_DEBUG <> 0 Then
1292: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Total Transfer price of item is '||to_char(x_transfer_price));
1293: End if;
1294:
1295: EXCEPTION
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1298: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexpected error:'||lStmtNumber||sqlerrm);

1294:
1295: EXCEPTION
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: If PG_DEBUG <> 0 Then
1298: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexpected error:'||lStmtNumber||sqlerrm);
1299: End if;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: CTO_MSG_PUB.Count_And_Get
1302: (p_msg_count => x_msg_count

Line 1308: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Expected error:'||lStmtNumber||sqlerrm);

1304: );
1305:
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: If PG_DEBUG <> 0 Then
1308: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Expected error:'||lStmtNumber||sqlerrm);
1309: End if;
1310: x_return_status := FND_API.G_RET_STS_ERROR;
1311: CTO_MSG_PUB.Count_And_Get
1312: (p_msg_count => x_msg_count

Line 1317: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Others error:'||lStmtNumber||sqlerrm);

1313: ,p_msg_data => x_msg_data);
1314:
1315: WHEN OTHERS THEN
1316: If PG_DEBUG <> 0 Then
1317: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Others error:'||lStmtNumber||sqlerrm);
1318: End if;
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1320: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1321: FND_MSG_PUB.Add_Exc_Msg