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_WIP_WRAPPER dependencies on FND_API

Line 790: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN

786: ,x_return_status => l_x_return_status
787: ,x_msg_count => l_x_msg_count
788: ,x_msg_data => l_x_msg_data );
789:
790: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
791: IF PG_DEBUG <> 0 THEN
792: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
793: END IF;
794: raise FND_API.G_EXC_ERROR;

Line 794: raise FND_API.G_EXC_ERROR;

790: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
791: IF PG_DEBUG <> 0 THEN
792: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
793: END IF;
794: raise FND_API.G_EXC_ERROR;
795:
796: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
797: IF PG_DEBUG <> 0 THEN
798: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');

Line 796: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

792: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
793: END IF;
794: raise FND_API.G_EXC_ERROR;
795:
796: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
797: IF PG_DEBUG <> 0 THEN
798: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');
799: END IF;
800: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 800: raise FND_API.G_EXC_UNEXPECTED_ERROR;

796: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
797: IF PG_DEBUG <> 0 THEN
798: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');
799: END IF;
800: raise FND_API.G_EXC_UNEXPECTED_ERROR;
801:
802: end if;
803: else
804: IF PG_DEBUG <> 0 THEN

Line 956: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN

952: IF PG_DEBUG <> 0 THEN
953: oe_debug_pub.add('get_order_lines: ' || 'Return status from Query_sourcing_org = '||l_x_return_status,1);
954: END IF;
955:
956: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
957:
958: IF l_can_create_supply = 'N' THEN --opm
959: IF PG_DEBUG <> 0 THEN
960: --would identify if line is skipped becuase of custom hook

Line 974: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

970: END IF;
971:
972: END IF; --l_can_create_supply
973:
974: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
975: IF PG_DEBUG <> 0 THEN
976: oe_debug_pub.add('get_order_lines: ' || 'Expected error occurred in Query_sourcing_org...',1);
977: END IF;
978: l_rows_errored := l_rows_errored + 1;

Line 982: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

978: l_rows_errored := l_rows_errored + 1;
979: -- we do not want to raise error here, since we want to process remaining lines
980: goto end_of_loop;
981:
982: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
983: IF PG_DEBUG <> 0 THEN
984: oe_debug_pub.add('get_order_lines: ' || 'Unexpected error occurred in Query_sourcing_org procedure...',1);
985: END IF;
986: l_rows_errored := l_rows_errored + 1;

Line 1040: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1036: x_return_status => l_x_return_status,
1037: x_msg_count => l_x_error_msg_count,
1038: x_msg_data => l_x_error_msg);
1039:
1040: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1041:
1042: IF PG_DEBUG <> 0 THEN
1043: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Hold Check: ' || l_x_return_status ||
1044: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);

Line 1055: if (l_x_hold_result_out = FND_API.G_TRUE) then

1051: OE_DEBUG_PUB.add('get_order_lines: ' || 'Success in Hold Check: ' || l_x_return_status ||
1052: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1053: END IF;
1054:
1055: if (l_x_hold_result_out = FND_API.G_TRUE) then
1056:
1057: IF PG_DEBUG <> 0 THEN
1058: OE_DEBUG_PUB.add('get_order_lines: ' || 'Hold Found on order line ' || to_char(WorkOrder_Rec.line_id), 1);
1059:

Line 1101: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then

1097: x_return_status => l_x_return_status,
1098: x_msg_count => l_x_msg_count,
1099: x_msg_data => l_x_msg_data);
1100:
1101: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then
1102: IF PG_DEBUG <> 0 THEN
1103: OE_DEBUG_PUB.add('get_order_lines: ' ||
1104: 'Expected error in Delivery_Planned: '
1105: || l_x_return_status

Line 1109: raise FND_API.G_EXC_ERROR;

1105: || l_x_return_status
1106: || ' For Order Line '
1107: ||to_char(WorkOrder_Rec.line_id), 1);
1108: END IF;
1109: raise FND_API.G_EXC_ERROR;
1110:
1111: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1112: IF PG_DEBUG <> 0 THEN
1113: OE_DEBUG_PUB.add('get_order_lines: ' ||

Line 1111: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1107: ||to_char(WorkOrder_Rec.line_id), 1);
1108: END IF;
1109: raise FND_API.G_EXC_ERROR;
1110:
1111: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1112: IF PG_DEBUG <> 0 THEN
1113: OE_DEBUG_PUB.add('get_order_lines: ' ||
1114: 'UnExpected error in Delivery_Planned: '
1115: || l_x_return_status

Line 1119: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1115: || l_x_return_status
1116: || ' For Order Line '
1117: ||to_char(WorkOrder_Rec.line_id), 1);
1118: END IF;
1119: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1120:
1121: else
1122: IF PG_DEBUG <> 0 THEN
1123: OE_DEBUG_PUB.add('get_order_lines: ' ||

Line 1130: if (l_x_result_out = FND_API.G_FALSE) then

1126: || ' For Order Line '
1127: ||to_char(WorkOrder_Rec.line_id), 1);
1128: END IF;
1129:
1130: if (l_x_result_out = FND_API.G_FALSE) then
1131: IF PG_DEBUG <> 0 THEN
1132: OE_DEBUG_PUB.add('get_order_lines: ' ||
1133: 'Order line not delivery planned'
1134: ||to_char(WorkOrder_Rec.line_id), 1);

Line 1187: IF (l_x_return_status = FND_API.G_RET_STS_ERROR) THEN

1183: x_return_status => l_x_return_status,
1184: x_msg_name => l_x_message_name,
1185: x_msg_txt => l_x_error_message);
1186:
1187: IF (l_x_return_status = FND_API.G_RET_STS_ERROR) THEN
1188: IF PG_DEBUG <> 0 THEN
1189: oe_debug_pub.add('get_order_lines: Expected error in Create Flow Schedule. Status:' || l_x_return_status);
1190: END IF;
1191: cto_msg_pub.cto_message('BOM', l_x_message_name);

Line 1195: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1191: cto_msg_pub.cto_message('BOM', l_x_message_name);
1192: l_rows_errored := l_rows_errored + 1;
1193: goto end_of_loop;
1194:
1195: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1196: IF PG_DEBUG <> 0 THEN
1197: oe_debug_pub.add('get_order_lines: Unexpected error in Create Flow Schedule. Status:' || l_x_return_status);
1198: END IF;
1199: cto_msg_pub.cto_message('BOM', l_x_message_name);

Line 1254: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1250: x_return_status => l_x_return_status,
1251: x_error_message => l_x_error_message,
1252: x_message_name => l_x_message_name);
1253:
1254: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1255: -- We dont want to raise error here, since we want to process other lines.
1256:
1257: IF PG_DEBUG <> 0 THEN
1258: oe_debug_pub.add('get_order_lines: ' || 'Insert Error Message: ' || l_x_error_message,1);

Line 1399: WHEN FND_API.G_EXC_ERROR THEN

1395: unlock_line_id (p_line_id); -- bugfix 3136206
1396: return 1; -- return success otherwise, w/f will be in retry mode ! --bugfix 2105156
1397:
1398:
1399: WHEN FND_API.G_EXC_ERROR THEN
1400: IF PG_DEBUG <> 0 THEN
1401: OE_DEBUG_PUB.add('get_order_lines: ' || 'Expected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);
1402: END IF;
1403: unlock_line_id (p_line_id); -- bugfix 3136206

Line 1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1402: END IF;
1403: unlock_line_id (p_line_id); -- bugfix 3136206
1404: return 1; -- should not error out in case of excpected error
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: IF PG_DEBUG <> 0 THEN
1408: OE_DEBUG_PUB.add('get_order_lines: ' || 'Unxpected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);
1409: END IF;
1410: unlock_line_id (p_line_id); -- bugfix 3136206

Line 1601: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN

1597: ,x_return_status => l_x_return_status
1598: ,x_msg_count => l_x_msg_count
1599: ,x_msg_data => l_x_msg_data );
1600:
1601: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1602: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1603: raise FND_API.G_EXC_ERROR;
1604:
1605: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1603: raise FND_API.G_EXC_ERROR;

1599: ,x_msg_data => l_x_msg_data );
1600:
1601: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1602: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1603: raise FND_API.G_EXC_ERROR;
1604:
1605: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1607: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1605: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1601: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1602: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1603: raise FND_API.G_EXC_ERROR;
1604:
1605: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1608:
1609: end if;

Line 1607: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1603: raise FND_API.G_EXC_ERROR;
1604:
1605: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1606: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1608:
1609: end if;
1610:
1611: else

Line 1666: if (l_status <> FND_API.G_RET_STS_SUCCESS) then

1662:
1663: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Msg: ' || l_msg_txt,1);
1664: END IF;
1665:
1666: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1667: /*---------------------------------------------------+
1668: Reservation unsuccessful. We had originally discussed
1669: purging the work order if reservation failed, but
1670: Biju Baby had explained that there were accounting

Line 1739: if (l_status <> FND_API.G_RET_STS_SUCCESS) then

1735:
1736: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Txt from respond to change order: ' || l_msg_txt,2);
1737: END IF;
1738:
1739: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1740:
1741: IF PG_DEBUG <> 0 THEN
1742: oe_debug_pub.add('reserve_wo_to_so: ' ||
1743: 'Deleting Reservation for ' ||

Line 1755: , p_init_msg_lst => fnd_api.g_true

1751:
1752: INV_RESERVATION_PUB.delete_reservation
1753: (
1754: p_api_version_number => 1.0
1755: , p_init_msg_lst => fnd_api.g_true
1756: , x_return_status => l_status
1757: , x_msg_count => l_msg_count
1758: , x_msg_data => l_msg_txt
1759: , p_rsv_rec => l_rsv_rec

Line 1833: WHEN FND_API.G_EXC_ERROR THEN

1829:
1830: EXCEPTION
1831:
1832: --begin bugfix 3014000
1833: WHEN FND_API.G_EXC_ERROR THEN
1834: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Expected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1835: unlock_line_id (lLineId); -- bugfix 3136206
1836: return 1; -- should not error out in case of excpected error
1837:

Line 1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1834: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Expected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1835: unlock_line_id (lLineId); -- bugfix 3136206
1836: return 1; -- should not error out in case of excpected error
1837:
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Unxpected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1840: unlock_line_id (lLineId); -- bugfix 3136206
1841: return 0;
1842: