APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CSF_DEBRIEF_PUB

Line 143: l_deb_rec csf_debrief_pub.debrief_rec_type;

139: l_cancelled_flag VARCHAR2(1);
140: l_closed_flag VARCHAR2(1);
141: l_completed_flag VARCHAR2(1);
142:
143: l_deb_rec csf_debrief_pub.debrief_rec_type;
144:
145: l_line_rec csf_debrief_pub.debrief_line_rec_type;
146: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
147:

Line 145: l_line_rec csf_debrief_pub.debrief_line_rec_type;

141: l_completed_flag VARCHAR2(1);
142:
143: l_deb_rec csf_debrief_pub.debrief_rec_type;
144:
145: l_line_rec csf_debrief_pub.debrief_line_rec_type;
146: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
147:
148:
149: l_debrief_header_id number;

Line 146: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;

142:
143: l_deb_rec csf_debrief_pub.debrief_rec_type;
144:
145: l_line_rec csf_debrief_pub.debrief_line_rec_type;
146: l_line_tbl csf_debrief_pub.debrief_line_tbl_type;
147:
148:
149: l_debrief_header_id number;
150: l_debrief_number number;

Line 223: csf_debrief_pub.create_debrief

219: then
220: -- Create a debrief header.
221: l_deb_rec.debrief_number := null ;
222:
223: csf_debrief_pub.create_debrief
224: ( p_api_version_number => 1.0
225: , p_init_msg_list => FND_API.G_TRUE
226: , p_commit => FND_API.G_FALSE
227: , p_debrief_rec => l_deb_rec

Line 243: || ' ROOT ERROR: csf_debrief_pub.create_debrief'

239: (
240: p_api_error => TRUE
241: );
242: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
243: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
244: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: return;
247: end if;

Line 481: csf_debrief_pub.create_debrief_lines

477: open c_task_obj_code ( p_record.task_assignment_id );
478: fetch c_task_obj_code into r_task_obj_code;
479: close c_task_obj_code;
480:
481: csf_debrief_pub.create_debrief_lines
482: ( p_api_version_number => 1.0
483: , p_init_msg_list => FND_API.G_TRUE
484: , p_commit => FND_API.G_FALSE
485: , x_return_status => x_return_status

Line 500: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'

496: (
497: p_api_error => TRUE
498: );
499: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
500: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
501: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: return;
504: end if;

Line 569: l_line_rec csf_debrief_pub.debrief_line_rec_type;

565:
566: --VARIABLE Declarations
567: r_cdl c_cdl%ROWTYPE;
568:
569: l_line_rec csf_debrief_pub.debrief_line_rec_type;
570: l_issuing_inventory_org_id csf_debrief_lines.issuing_inventory_org_id%TYPE;
571: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;
572:
573: l_debrief_header_id NUMBER;

Line 825: csf_debrief_pub.update_debrief_line

821: END IF;
822:
823:
824: -- Update the debrief line
825: csf_debrief_pub.update_debrief_line
826: ( p_api_version_number => 1.0
827: , p_init_msg_list => FND_API.G_TRUE
828: , p_commit => FND_API.G_FALSE
829: , x_return_status => x_return_status

Line 840: || ' ROOT ERROR: csf_debrief_pub.update_debrief_line'

836: THEN
837: /*** exception occurred in API -> return errmsg ***/
838: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error=> TRUE);
839: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
840: || ' ROOT ERROR: csf_debrief_pub.update_debrief_line'
841: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: RETURN;
844: END IF;