DBA Data[Home] [Help]

APPS.CSL_DEBRIEF_PKG dependencies on FND_GLOBAL

Line 111: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;

107: l_deb_rec.debrief_date := r_csf_debrief_headers.debrief_date;
108: l_deb_rec.debrief_status_id := r_csf_debrief_headers.debrief_status_id;
109: l_deb_rec.task_assignment_id := r_csf_debrief_headers.task_assignment_id;
110: l_deb_rec.last_update_date := l_date;
111: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;
112: l_deb_rec.creation_date := l_date;
113: l_deb_rec.created_by := FND_GLOBAL.USER_ID;
114: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
115: l_deb_rec.attribute1 := r_csf_debrief_headers.attribute1;

Line 113: l_deb_rec.created_by := FND_GLOBAL.USER_ID;

109: l_deb_rec.task_assignment_id := r_csf_debrief_headers.task_assignment_id;
110: l_deb_rec.last_update_date := l_date;
111: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;
112: l_deb_rec.creation_date := l_date;
113: l_deb_rec.created_by := FND_GLOBAL.USER_ID;
114: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
115: l_deb_rec.attribute1 := r_csf_debrief_headers.attribute1;
116: l_deb_rec.attribute2 := r_csf_debrief_headers.attribute2;
117: l_deb_rec.attribute3 := r_csf_debrief_headers.attribute3;

Line 114: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

110: l_deb_rec.last_update_date := l_date;
111: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;
112: l_deb_rec.creation_date := l_date;
113: l_deb_rec.created_by := FND_GLOBAL.USER_ID;
114: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
115: l_deb_rec.attribute1 := r_csf_debrief_headers.attribute1;
116: l_deb_rec.attribute2 := r_csf_debrief_headers.attribute2;
117: l_deb_rec.attribute3 := r_csf_debrief_headers.attribute3;
118: l_deb_rec.attribute4 := r_csf_debrief_headers.attribute4;

Line 489: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

485: jtm_message_log_pkg.Log_Msg
486: ( v_object_id => p_header_id --p_record.DEBRIEF_LINE_ID
487: , v_object_name => g_object_name
488: , v_message => 'Exception occurred in APPLY_INSERT_HEADER:' ||
489: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
490: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
491: END IF;
492:
493: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT_HEADER', sqlerrm);

Line 755: l_line_rec.last_updated_by := FND_GLOBAL.USER_ID;

751: l_line_rec.receiving_inventory_org_id := p_record.receiving_inventory_org_id;
752: l_line_rec.receiving_sub_inventory_code := p_record.receiving_sub_inventory_code;
753: l_line_rec.receiving_locator_id := p_record.receiving_locator_id;
754: l_line_rec.last_update_date := l_date;
755: l_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
756: l_line_rec.creation_date := l_date;
757: l_line_rec.created_by := FND_GLOBAL.USER_ID;
758: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
759: l_line_rec.spare_update_status := l_spare_update_status;

Line 757: l_line_rec.created_by := FND_GLOBAL.USER_ID;

753: l_line_rec.receiving_locator_id := p_record.receiving_locator_id;
754: l_line_rec.last_update_date := l_date;
755: l_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
756: l_line_rec.creation_date := l_date;
757: l_line_rec.created_by := FND_GLOBAL.USER_ID;
758: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
759: l_line_rec.spare_update_status := l_spare_update_status;
760: l_line_rec.inventory_item_id := p_record.inventory_item_id;
761: l_line_rec.txn_billing_type_id := p_record.txn_billing_type_id;

Line 758: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

754: l_line_rec.last_update_date := l_date;
755: l_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
756: l_line_rec.creation_date := l_date;
757: l_line_rec.created_by := FND_GLOBAL.USER_ID;
758: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
759: l_line_rec.spare_update_status := l_spare_update_status;
760: l_line_rec.inventory_item_id := p_record.inventory_item_id;
761: l_line_rec.txn_billing_type_id := p_record.txn_billing_type_id;
762: l_line_rec.service_date := p_record.service_date;

Line 857: , v_message => 'Exception occurred in APPLY_INSERT:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

853: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
854: jtm_message_log_pkg.Log_Msg
855: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
856: , v_object_name => g_object_name
857: , v_message => 'Exception occurred in APPLY_INSERT:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
858: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
859: END IF;
860:
861: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT_LINE', sqlerrm);

Line 988: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;

984: l_deb_rec.debrief_date := r_csf_debrief_headers.debrief_date;
985: l_deb_rec.debrief_status_id := r_csf_debrief_headers.debrief_status_id;
986: l_deb_rec.task_assignment_id := r_csf_debrief_headers.task_assignment_id;
987: l_deb_rec.last_update_date := l_date;
988: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;
989: l_deb_rec.creation_date := l_date;
990: l_deb_rec.created_by := FND_GLOBAL.USER_ID;
991: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
992: l_deb_rec.attribute1 := r_csf_debrief_headers.attribute1;

Line 990: l_deb_rec.created_by := FND_GLOBAL.USER_ID;

986: l_deb_rec.task_assignment_id := r_csf_debrief_headers.task_assignment_id;
987: l_deb_rec.last_update_date := l_date;
988: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;
989: l_deb_rec.creation_date := l_date;
990: l_deb_rec.created_by := FND_GLOBAL.USER_ID;
991: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
992: l_deb_rec.attribute1 := r_csf_debrief_headers.attribute1;
993: l_deb_rec.attribute2 := r_csf_debrief_headers.attribute2;
994: l_deb_rec.attribute3 := r_csf_debrief_headers.attribute3;

Line 991: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

987: l_deb_rec.last_update_date := l_date;
988: l_deb_rec.last_updated_by := FND_GLOBAL.USER_ID;
989: l_deb_rec.creation_date := l_date;
990: l_deb_rec.created_by := FND_GLOBAL.USER_ID;
991: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
992: l_deb_rec.attribute1 := r_csf_debrief_headers.attribute1;
993: l_deb_rec.attribute2 := r_csf_debrief_headers.attribute2;
994: l_deb_rec.attribute3 := r_csf_debrief_headers.attribute3;
995: l_deb_rec.attribute4 := r_csf_debrief_headers.attribute4;

Line 1116: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

1112: jtm_message_log_pkg.Log_Msg
1113: ( v_object_id => p_header_id --p_record.DEBRIEF_LINE_ID
1114: , v_object_name => g_object_name
1115: , v_message => 'Exception occurred in APPLY_UPDATE_HEADER:' ||
1116: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1117: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1118: END IF;
1119:
1120: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE_HEADER', sqlerrm);

Line 1185: , v_message => 'Exception occurred in APPLY_UPDATE:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

1181: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1182: jtm_message_log_pkg.Log_Msg
1183: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1184: , v_object_name => g_object_name
1185: , v_message => 'Exception occurred in APPLY_UPDATE:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1186: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1187: END IF;
1188:
1189: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);

Line 1370: , v_message => 'Exception occurred in PROCESS_DEBRIEF:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

1366: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1367: jtm_message_log_pkg.Log_Msg
1368: ( v_object_id => null
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:

Line 1542: , v_message => 'Exception occurred in Process_Debrief_No_Headers: ' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

1538: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1539: jtm_message_log_pkg.Log_Msg
1540: ( v_object_id => null
1541: , v_object_name => g_object_name
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;

Line 1629: || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

1625: jtm_message_log_pkg.Log_Msg
1626: ( v_object_id => null
1627: , v_object_name => g_object_name
1628: , v_message => 'Exception occurred in PROCESS_DEBRIEF_NO_LINES: '
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;