APPS.ZPB_DC_WF dependencies on FND_FILE

Line 688: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;

684: '_' || l_distribute_type||
685: '_' || l_substr_templ_name ||
686: '_' || l_char_date;
687:
688: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;
689:
690: wf_event.AddParameterToList(
691: p_name => 'DC_OBJECT_ID',
692: p_value => p_object_id,

Line 1121: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_template_id=' || l_template_id ) ;

1117: ItemKey => ItemKey,
1118: aname => 'DC_TEMPLATE_ID',
1119: avalue => l_template_id );
1120: --
1121: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_template_id=' || l_template_id ) ;
1122: --------------------------------------
1123: -- Processing --
1124: --------------------------------------
1125: -- Check whether distribution happened --

Line 1131: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_ws_count=' || l_ws_count ) ;

1127: INTO l_ws_count
1128: FROM zpb_dc_objects
1129: WHERE template_id = l_template_id
1130: AND object_type = 'W';
1131: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_ws_count=' || l_ws_count ) ;
1132:
1133: -- Get the necessary info for processing --
1134: FOR worksheet_rec IN (
1135: SELECT distribution_method,

Line 1161: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_ws_status_count=' || l_ws_status_count ) ;

1157: AND template_id = l_template_id
1158: AND object_type = 'W'
1159: AND status NOT IN ('SUBMITTED_TO_SHARED')
1160: AND (end_date is null OR end_date > sysdate);
1161: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_ws_status_count=' || l_ws_status_count ) ;
1162:
1163: IF (l_ws_status_count = 0) THEN
1164: resultout := 'COMPLETE:UPDATE_STATUS';
1165: ELSE

Line 1527: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;

1523: '_' || l_substr_templ_name ||
1524: '_' || l_char_date;
1525:
1526:
1527: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;
1528:
1529: wf_event.AddParameterToList(
1530: p_name => 'DC_OBJECT_ID',
1531: p_value => p_object_id,

Line 2517: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;

2513: '_' || l_approval_type||
2514: '_' || l_substr_templ_name ||
2515: '_' || l_char_date;
2516:
2517: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;
2518:
2519: -- Create the roles for Approver and Submitter users
2520: l_char_date := to_char(sysdate, 'J-SSSSS');
2521: l_appr_rolename := 'ZPB_APP_APPR'|| to_char(p_object_id) || '-' || l_char_date;

Line 2728: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;

2724: '_' || l_rejection_type||
2725: '_' || l_substr_templ_name ||
2726: '_' || l_char_date;
2727:
2728: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;
2729:
2730: -- Create the roles for Approver and Submitter users
2731: l_char_date := to_char(sysdate, 'J-SSSSS');
2732: l_appr_rolename := 'ZPB_REJ_APPR'|| to_char(p_object_id) || '-' || l_char_date;