APPS.BOMDELEX dependencies on FND_FILE

Line 38: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

34: and rexplode_flag = 1 ;
35:
36: BEGIN
37: /* Print the list of parameters */
38: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
39: FND_FILE.PUT_LINE( FND_FILE.LOG,'Top_Bill_sequence_id='||to_char(top_bill_seq_id));
40: FND_FILE.PUT_LINE( FND_FILE.LOG,'Explosion Type='||expl_type);
41: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
42:

Line 39: FND_FILE.PUT_LINE( FND_FILE.LOG,'Top_Bill_sequence_id='||to_char(top_bill_seq_id));

35:
36: BEGIN
37: /* Print the list of parameters */
38: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
39: FND_FILE.PUT_LINE( FND_FILE.LOG,'Top_Bill_sequence_id='||to_char(top_bill_seq_id));
40: FND_FILE.PUT_LINE( FND_FILE.LOG,'Explosion Type='||expl_type);
41: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
42:
43: /* Make sure the right set of parameter are passed */

Line 40: FND_FILE.PUT_LINE( FND_FILE.LOG,'Explosion Type='||expl_type);

36: BEGIN
37: /* Print the list of parameters */
38: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
39: FND_FILE.PUT_LINE( FND_FILE.LOG,'Top_Bill_sequence_id='||to_char(top_bill_seq_id));
40: FND_FILE.PUT_LINE( FND_FILE.LOG,'Explosion Type='||expl_type);
41: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
42:
43: /* Make sure the right set of parameter are passed */
44: IF (top_bill_seq_id is NULL) Or (expl_type IS NULL) THEN

Line 41: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

37: /* Print the list of parameters */
38: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
39: FND_FILE.PUT_LINE( FND_FILE.LOG,'Top_Bill_sequence_id='||to_char(top_bill_seq_id));
40: FND_FILE.PUT_LINE( FND_FILE.LOG,'Explosion Type='||expl_type);
41: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
42:
43: /* Make sure the right set of parameter are passed */
44: IF (top_bill_seq_id is NULL) Or (expl_type IS NULL) THEN
45: raise invalid_argument_list ;

Line 84: FND_FILE.PUT_LINE(FND_FILE.LOG,'Either Top assembly Item Id or Explosion type is not specified') ;

80: WHERE TOP_BILL_SEQUENCE_ID = top_bill_seq_id
81: AND EXPLOSION_TYPE = expl_type
82: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;
83: commit;
84: FND_FILE.PUT_LINE(FND_FILE.LOG,'Either Top assembly Item Id or Explosion type is not specified') ;
85: RETCODE := 2;
86: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
87: When Others Then
88: Rollback;

Line 96: FND_FILE.PUT_LINE(FND_FILE.LOG,'The concurrent request did not complete

92: AND EXPLOSION_TYPE = expl_type
93: AND SORT_ORDER = Bom_Common_Definitions.G_Bom_Init_SortCode;
94: commit;
95:
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'The concurrent request did not complete
97: successfully');
98: FND_FILE.PUT_LINE(fnd_file.log,'Others exception raised');
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others : '||SQLCODE || ':'||SQLERRM) ;
100: RETCODE := 2;

Line 98: FND_FILE.PUT_LINE(fnd_file.log,'Others exception raised');

94: commit;
95:
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'The concurrent request did not complete
97: successfully');
98: FND_FILE.PUT_LINE(fnd_file.log,'Others exception raised');
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others : '||SQLCODE || ':'||SQLERRM) ;
100: RETCODE := 2;
101: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
102:

Line 99: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others : '||SQLCODE || ':'||SQLERRM) ;

95:
96: FND_FILE.PUT_LINE(FND_FILE.LOG,'The concurrent request did not complete
97: successfully');
98: FND_FILE.PUT_LINE(fnd_file.log,'Others exception raised');
99: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others : '||SQLCODE || ':'||SQLERRM) ;
100: RETCODE := 2;
101: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
102:
103: END DELETE_BOM_EXPLOSIONS;