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 750: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN

746: ,x_return_status => l_x_return_status
747: ,x_msg_count => l_x_msg_count
748: ,x_msg_data => l_x_msg_data );
749:
750: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
751: IF PG_DEBUG <> 0 THEN
752: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
753: END IF;
754: raise FND_API.G_EXC_ERROR;

Line 754: raise FND_API.G_EXC_ERROR;

750: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
751: IF PG_DEBUG <> 0 THEN
752: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
753: END IF;
754: raise FND_API.G_EXC_ERROR;
755:
756: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: IF PG_DEBUG <> 0 THEN
758: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');

Line 756: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

752: oe_debug_pub.add('get_order_lines: '|| 'Expected Error in Set_Created_By_Context.');
753: END IF;
754: raise FND_API.G_EXC_ERROR;
755:
756: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: IF PG_DEBUG <> 0 THEN
758: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');
759: END IF;
760: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 760: raise FND_API.G_EXC_UNEXPECTED_ERROR;

756: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: IF PG_DEBUG <> 0 THEN
758: oe_debug_pub.add('get_order_lines: '|| 'UnExpected Error in Set_Created_By_Context.');
759: END IF;
760: raise FND_API.G_EXC_UNEXPECTED_ERROR;
761:
762: end if;
763: else
764: IF PG_DEBUG <> 0 THEN

Line 916: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN

912: IF PG_DEBUG <> 0 THEN
913: oe_debug_pub.add('get_order_lines: ' || 'Return status from Query_sourcing_org = '||l_x_return_status,1);
914: END IF;
915:
916: IF l_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
917:
918: IF l_can_create_supply = 'N' THEN --opm
919: IF PG_DEBUG <> 0 THEN
920: --would identify if line is skipped becuase of custom hook

Line 934: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

930: END IF;
931:
932: END IF; --l_can_create_supply
933:
934: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
935: IF PG_DEBUG <> 0 THEN
936: oe_debug_pub.add('get_order_lines: ' || 'Expected error occurred in Query_sourcing_org...',1);
937: END IF;
938: l_rows_errored := l_rows_errored + 1;

Line 942: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

938: l_rows_errored := l_rows_errored + 1;
939: -- we do not want to raise error here, since we want to process remaining lines
940: goto end_of_loop;
941:
942: ELSIF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: IF PG_DEBUG <> 0 THEN
944: oe_debug_pub.add('get_order_lines: ' || 'Unexpected error occurred in Query_sourcing_org procedure...',1);
945: END IF;
946: l_rows_errored := l_rows_errored + 1;

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

992: x_return_status => l_x_return_status,
993: x_msg_count => l_x_error_msg_count,
994: x_msg_data => l_x_error_msg);
995:
996: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then
997:
998: IF PG_DEBUG <> 0 THEN
999: OE_DEBUG_PUB.add('get_order_lines: ' || 'FAILED in Hold Check: ' || l_x_return_status ||
1000: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);

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

1007: OE_DEBUG_PUB.add('get_order_lines: ' || 'Success in Hold Check: ' || l_x_return_status ||
1008: ' For Order Line ' || to_char(WorkOrder_Rec.line_id), 1);
1009: END IF;
1010:
1011: if (l_x_hold_result_out = FND_API.G_TRUE) then
1012:
1013: IF PG_DEBUG <> 0 THEN
1014: OE_DEBUG_PUB.add('get_order_lines: ' || 'Hold Found on order line ' || to_char(WorkOrder_Rec.line_id), 1);
1015:

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

1053: x_return_status => l_x_return_status,
1054: x_msg_count => l_x_msg_count,
1055: x_msg_data => l_x_msg_data);
1056:
1057: if (l_x_return_status = FND_API.G_RET_STS_ERROR) then
1058: IF PG_DEBUG <> 0 THEN
1059: OE_DEBUG_PUB.add('get_order_lines: ' ||
1060: 'Expected error in Delivery_Planned: '
1061: || l_x_return_status

Line 1065: raise FND_API.G_EXC_ERROR;

1061: || l_x_return_status
1062: || ' For Order Line '
1063: ||to_char(WorkOrder_Rec.line_id), 1);
1064: END IF;
1065: raise FND_API.G_EXC_ERROR;
1066:
1067: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1068: IF PG_DEBUG <> 0 THEN
1069: OE_DEBUG_PUB.add('get_order_lines: ' ||

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

1063: ||to_char(WorkOrder_Rec.line_id), 1);
1064: END IF;
1065: raise FND_API.G_EXC_ERROR;
1066:
1067: elsif (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1068: IF PG_DEBUG <> 0 THEN
1069: OE_DEBUG_PUB.add('get_order_lines: ' ||
1070: 'UnExpected error in Delivery_Planned: '
1071: || l_x_return_status

Line 1075: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1071: || l_x_return_status
1072: || ' For Order Line '
1073: ||to_char(WorkOrder_Rec.line_id), 1);
1074: END IF;
1075: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1076:
1077: else
1078: IF PG_DEBUG <> 0 THEN
1079: OE_DEBUG_PUB.add('get_order_lines: ' ||

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

1082: || ' For Order Line '
1083: ||to_char(WorkOrder_Rec.line_id), 1);
1084: END IF;
1085:
1086: if (l_x_result_out = FND_API.G_FALSE) then
1087: IF PG_DEBUG <> 0 THEN
1088: OE_DEBUG_PUB.add('get_order_lines: ' ||
1089: 'Order line not delivery planned'
1090: ||to_char(WorkOrder_Rec.line_id), 1);

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

1111: x_return_status => l_x_return_status,
1112: x_error_message => l_x_error_message,
1113: x_message_name => l_x_message_name);
1114:
1115: if (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1116: -- We dont want to raise error here, since we want to process other lines.
1117:
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add('get_order_lines: ' || 'Insert Error Message: ' || l_x_error_message,1);

Line 1255: WHEN FND_API.G_EXC_ERROR THEN

1251: unlock_line_id (p_line_id); -- bugfix 3136206
1252: return 1; -- return success otherwise, w/f will be in retry mode ! --bugfix 2105156
1253:
1254:
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: IF PG_DEBUG <> 0 THEN
1257: OE_DEBUG_PUB.add('get_order_lines: ' || 'Expected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);
1258: END IF;
1259: unlock_line_id (p_line_id); -- bugfix 3136206

Line 1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1258: END IF;
1259: unlock_line_id (p_line_id); -- bugfix 3136206
1260: return 1; -- should not error out in case of excpected error
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: IF PG_DEBUG <> 0 THEN
1264: OE_DEBUG_PUB.add('get_order_lines: ' || 'Unxpected Error in CTOWIPWB.get_order_lines (stmt: '||l_stmt_num||')' ,1);
1265: END IF;
1266: unlock_line_id (p_line_id); -- bugfix 3136206

Line 1455: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN

1451: ,x_return_status => l_x_return_status
1452: ,x_msg_count => l_x_msg_count
1453: ,x_msg_data => l_x_msg_data );
1454:
1455: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1456: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1457: raise FND_API.G_EXC_ERROR;
1458:
1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1457: raise FND_API.G_EXC_ERROR;

1453: ,x_msg_data => l_x_msg_data );
1454:
1455: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1456: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1457: raise FND_API.G_EXC_ERROR;
1458:
1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1461: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1455: if l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1456: oe_debug_pub.add('reserve_wo_to_so: '|| 'Expected Error in Set_Created_By_Context.');
1457: raise FND_API.G_EXC_ERROR;
1458:
1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1462:
1463: end if;

Line 1461: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1457: raise FND_API.G_EXC_ERROR;
1458:
1459: elsif l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('reserve_wo_to_so: '|| 'UnExpected Error in Set_Created_By_Context.');
1461: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1462:
1463: end if;
1464:
1465: else

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

1516:
1517: oe_debug_pub.add('reserve_wo_to_so: ' || 'Reservation Msg: ' || l_msg_txt,1);
1518: END IF;
1519:
1520: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1521: /*---------------------------------------------------+
1522: Reservation unsuccessful. We had originally discussed
1523: purging the work order if reservation failed, but
1524: Biju Baby had explained that there were accounting

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

1589:
1590: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Txt from respond to change order: ' || l_msg_txt,2);
1591: END IF;
1592:
1593: if (l_status <> FND_API.G_RET_STS_SUCCESS) then
1594:
1595: IF PG_DEBUG <> 0 THEN
1596: oe_debug_pub.add('reserve_wo_to_so: ' ||
1597: 'Deleting Reservation for ' ||

Line 1609: , p_init_msg_lst => fnd_api.g_true

1605:
1606: INV_RESERVATION_PUB.delete_reservation
1607: (
1608: p_api_version_number => 1.0
1609: , p_init_msg_lst => fnd_api.g_true
1610: , x_return_status => l_status
1611: , x_msg_count => l_msg_count
1612: , x_msg_data => l_msg_txt
1613: , p_rsv_rec => l_rsv_rec

Line 1687: WHEN FND_API.G_EXC_ERROR THEN

1683:
1684: EXCEPTION
1685:
1686: --begin bugfix 3014000
1687: WHEN FND_API.G_EXC_ERROR THEN
1688: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Expected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1689: unlock_line_id (lLineId); -- bugfix 3136206
1690: return 1; -- should not error out in case of excpected error
1691:

Line 1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1688: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Expected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1689: unlock_line_id (lLineId); -- bugfix 3136206
1690: return 1; -- should not error out in case of excpected error
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: OE_DEBUG_PUB.add('reserve_wo_to_so: '|| 'Unxpected Error in CTOWIPWB.reserve_wo_to_so (stmt: '||l_stmt_num||')' );
1694: unlock_line_id (lLineId); -- bugfix 3136206
1695: return 0;
1696: