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.CSL_DEBRIEF_PKG dependencies on FND_API

Line 134: , p_init_msg_list => FND_API.G_TRUE

130: l_deb_rec.attribute_category := r_csf_debrief_headers.attribute_category;
131:
132: csf_debrief_pub.create_debrief
133: ( p_api_version_number => 1.0
134: , p_init_msg_list => FND_API.G_TRUE
135: , p_commit => FND_API.G_FALSE
136: , p_debrief_rec => l_deb_rec
137: , p_debrief_line_tbl => l_line_tbl
138: , x_debrief_header_id => l_debrief_header_id

Line 135: , p_commit => FND_API.G_FALSE

131:
132: csf_debrief_pub.create_debrief
133: ( p_api_version_number => 1.0
134: , p_init_msg_list => FND_API.G_TRUE
135: , p_commit => FND_API.G_FALSE
136: , p_debrief_rec => l_deb_rec
137: , p_debrief_line_tbl => l_line_tbl
138: , x_debrief_header_id => l_debrief_header_id
139: , x_return_status => x_return_status

Line 144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: , x_msg_count => l_msg_count
141: , x_msg_data => l_msg_data
142: );
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: /*** exception occurred in API -> return errmsg ***/
146: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
147: (
148: p_api_error => TRUE

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: , v_message => 'Leaving ' || g_object_name || '.CREATE_DEBRIEF_HEADER : ' || p_error_msg
172: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
173: END IF;
174:
175: x_return_status := FND_API.G_RET_STS_ERROR;
176:
177: END CREATE_DEBRIEF_HEADER;
178:
179: /***

Line 360: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

356: CREATE_DEBRIEF_HEADER(l_header_id, p_error_msg, l_return_status);
357:
358: -- Delete debrief header record from debrief header inqueue.
359: /*** was record processed successfully? ***/
360: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
361: /*** Yes -> delete record from inqueue ***/
362: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
363: jtm_message_log_pkg.Log_Msg
364: ( v_object_id => l_header_id -- put PK column here

Line 384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

380: x_return_status => l_return_status
381: );
382:
383: /*** was delete successful? ***/
384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** no -> rollback ***/
386: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
387: jtm_message_log_pkg.Log_Msg
388: ( v_object_id => p_header_id --p_record.debrief_header_id

Line 421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

417: ,x_return_status => l_return_status
418: );
419:
420: /*** Was defer successful? ***/
421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
422: /*** no -> rollback ***/
423: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
424: jtm_message_log_pkg.Log_Msg
425: ( v_object_id => p_header_id --p_record.debrief_header_id

Line 461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

457: ,P_ERROR_MSG => p_error_msg
458: ,X_RETURN_STATUS => l_return_status
459: );
460: /*** Was defer successful? ***/
461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
462: /*** no -> rollback ***/
463: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
464: jtm_message_log_pkg.Log_Msg
465: ( v_object_id => p_header_id --p_record.debrief_header_id

Line 508: x_return_status := FND_API.G_RET_STS_ERROR;

504: '.APPLY_INSERT_HEADER'
505: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: END APPLY_INSERT_HEADER;
510:
511:
512: /* New Procedure for ER - 3218717 */

Line 702: , p_init_msg_list => FND_API.G_TRUE

698: CLOSE c_debrief_header;
699:
700: csp_transactions_pub.transact_material
701: ( p_api_version => 1.0
702: , p_init_msg_list => FND_API.G_TRUE
703: , p_commit => FND_API.G_FALSE
704: , px_transaction_id => l_transaction_id
705: , px_transaction_header_id => l_transaction_header_id
706: , p_inventory_item_id => p_record.inventory_item_id

Line 703: , p_commit => FND_API.G_FALSE

699:
700: csp_transactions_pub.transact_material
701: ( p_api_version => 1.0
702: , p_init_msg_list => FND_API.G_TRUE
703: , p_commit => FND_API.G_FALSE
704: , px_transaction_id => l_transaction_id
705: , px_transaction_header_id => l_transaction_header_id
706: , p_inventory_item_id => p_record.inventory_item_id
707: , p_organization_id => l_inventory_org_id

Line 730: IF l_return_status = FND_API.G_RET_STS_SUCCESS

726: , x_msg_data => l_msg_data
727: );
728:
729: -- Check whether API error occurred
730: IF l_return_status = FND_API.G_RET_STS_SUCCESS
731: THEN
732: -- Successful -> set spares update status flag in debrief line to 'SUCCEEDED',
733: -- so the quantities won't be updated again when the FSE confirms the debriefline
734: -- in connected debrief

Line 818: , p_init_msg_list => FND_API.G_TRUE

814: CLOSE c_task_obj_code;
815:
816: csf_debrief_pub.create_debrief_lines
817: ( p_api_version_number => 1.0
818: , p_init_msg_list => FND_API.G_TRUE
819: , p_commit => FND_API.G_FALSE
820: , x_return_status => x_return_status
821: , x_msg_count => l_msg_count
822: , x_msg_data => l_msg_data

Line 819: , p_commit => FND_API.G_FALSE

815:
816: csf_debrief_pub.create_debrief_lines
817: ( p_api_version_number => 1.0
818: , p_init_msg_list => FND_API.G_TRUE
819: , p_commit => FND_API.G_FALSE
820: , x_return_status => x_return_status
821: , x_msg_count => l_msg_count
822: , x_msg_data => l_msg_data
823: , p_debrief_header_id => l_header_id

Line 828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

824: , p_debrief_line_tbl => l_line_tbl
825: , p_source_object_type_code => r_task_obj_code.source_object_type_code
826: );
827:
828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
829: /*** exception occurred in API -> return errmsg ***/
830: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
831: (
832: p_api_error => TRUE

Line 875: x_return_status := FND_API.G_RET_STS_ERROR;

871: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT_LINE'
872: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
873: END IF;
874:
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END APPLY_INSERT_LINE;
877:
878:
879: /***

Line 1011: , p_init_msg_list => FND_API.G_TRUE

1007: l_deb_rec.attribute_category := r_csf_debrief_headers.attribute_category;
1008:
1009: csf_debrief_pub.update_debrief
1010: ( p_api_version_number => 1.0
1011: , p_init_msg_list => FND_API.G_TRUE
1012: , p_commit => FND_API.G_FALSE
1013: , p_debrief_rec => l_deb_rec
1014: , x_return_status => x_return_status
1015: , x_msg_count => l_msg_count

Line 1012: , p_commit => FND_API.G_FALSE

1008:
1009: csf_debrief_pub.update_debrief
1010: ( p_api_version_number => 1.0
1011: , p_init_msg_list => FND_API.G_TRUE
1012: , p_commit => FND_API.G_FALSE
1013: , p_debrief_rec => l_deb_rec
1014: , x_return_status => x_return_status
1015: , x_msg_count => l_msg_count
1016: , x_msg_data => l_msg_data

Line 1022: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1018:
1019: -- Delete debrief header record from debrief header inqueue.
1020:
1021: /*** was record processed successfully? ***/
1022: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1023: /*** Yes -> delete record from inqueue ***/
1024: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1025: jtm_message_log_pkg.Log_Msg
1026: ( v_object_id => l_header_id -- put PK column here

Line 1046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1042: x_return_status => l_return_status
1043: );
1044:
1045: /*** was delete successful? ***/
1046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1047: /*** no -> rollback ***/
1048: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1049: jtm_message_log_pkg.Log_Msg
1050: ( v_object_id => p_header_id --p_record.debrief_header_id

Line 1086: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1082: ,x_return_status => l_return_status
1083: );
1084:
1085: /*** Was defer successful? ***/
1086: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1087: /*** no -> rollback ***/
1088: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1089: jtm_message_log_pkg.Log_Msg
1090: ( v_object_id => p_header_id --p_record.debrief_header_id

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: '.APPLY_UPDATE_HEADER'
1132: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1133: END IF;
1134:
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: END APPLY_UPDATE_HEADER;
1137:
1138:
1139: /***

Line 1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

1158: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1159: END IF;
1160:
1161: -- For Debrief no update is possible, so return success
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1165: /*** exception occurred in API -> return errmsg ***/
1166: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 1164: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1160:
1161: -- For Debrief no update is possible, so return success
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1163:
1164: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1165: /*** exception occurred in API -> return errmsg ***/
1166: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
1167: (
1168: p_api_error => TRUE

Line 1203: x_return_status := FND_API.G_RET_STS_ERROR;

1199: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
1200: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1201: END IF;
1202:
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END APPLY_UPDATE;
1205:
1206: /***
1207: This procedure is called from APPLY_CLIENT_CHANGES and processes all

Line 1262: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1258: , x_return_status => x_return_status
1259: );
1260:
1261: /*** was record processed successfully? ***/
1262: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1263: /*** Yes -> delete record from inqueue ***/
1264: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1265: jtm_message_log_pkg.Log_Msg
1266: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here

Line 1285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1281: x_return_status
1282: );
1283:
1284: /*** was delete successful? ***/
1285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1286: /*** no -> rollback ***/
1287: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1288: jtm_message_log_pkg.Log_Msg
1289: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here

Line 1298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1294: ROLLBACK TO save_rec;
1295: END IF;
1296: END IF;
1297:
1298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1299: /*** Record was not processed successfully or delete failed
1300: -> defer and reject record ***/
1301: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1302: jtm_message_log_pkg.Log_Msg

Line 1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1318: , x_return_status
1319: );
1320:
1321: /*** Was defer successful? ***/
1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1323: /*** no -> rollback ***/
1324: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1325: jtm_message_log_pkg.Log_Msg
1326: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here

Line 1373: x_return_status := FND_API.G_RET_STS_ERROR;

1369: , v_object_name => g_object_name
1370: , v_message => 'Exception occurred in PROCESS_DEBRIEF:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1371: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1372: END IF;
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374:
1375: END PROCESS_DEBRIEF;
1376:
1377: /***

Line 1441: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1437: );
1438: END IF;
1439:
1440: /*** was record processed successfully? ***/
1441: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1442: /*** Yes -> delete record from inqueue ***/
1443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1444: jtm_message_log_pkg.Log_Msg
1445: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here

Line 1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1460: x_return_status
1461: );
1462:
1463: /*** was delete successful? ***/
1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: /*** no -> rollback ***/
1466: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1467: jtm_message_log_pkg.Log_Msg
1468: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here

Line 1477: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1473: ROLLBACK TO save_rec;
1474: END IF;
1475: END IF;
1476:
1477: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1478: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
1479: --Since the record was not processed successfully, rollback to the point before
1480: --calling APPLY_INSERT_LINE
1481: ROLLBACK to save_rec;

Line 1503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1499: , x_return_status
1500: );
1501:
1502: /*** Was defer successful? ***/
1503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1504: /*** no -> rollback ***/
1505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1506: jtm_message_log_pkg.Log_Msg
1507: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: , v_message => 'Exception occurred in Process_Debrief_No_Headers: ' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1543: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1544: END IF;
1545:
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547:
1548: END PROCESS_DEBRIEF_NO_HEADERS;
1549:
1550: /***

Line 1633: x_return_status := FND_API.G_RET_STS_ERROR;

1629: || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1630: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1631: END IF;
1632:
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634:
1635: END PROCESS_DEBRIEF_NO_LINES;
1636:
1637: /***

Line 1654: x_return_status := FND_API.G_RET_STS_SUCCESS;

1650: x_return_status IN OUT NOCOPY VARCHAR2
1651: ) IS
1652: BEGIN
1653: g_debug_level := p_debug_level;
1654: x_return_status := FND_API.G_RET_STS_SUCCESS;
1655: g_header_id := NULL;
1656: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1657: jtm_message_log_pkg.Log_Msg
1658: ( v_object_id => null