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.PO_PALT_MS_COMPLETION dependencies on FND_FILE

Line 158: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the Calculation of Milestone Completion Date');

154: AND ACTUAL_COMPLETION_DATE IS NULL
155: AND ASSIGNMENT_ID = l_Assignment_Id;
156:
157: BEGIN
158: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the Calculation of Milestone Completion Date');
159:
160: IF (Use_Custom_Hook = 'Y') THEN
161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is ON');
162: l_Use_Custom_Hook := TRUE;

Line 161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is ON');

157: BEGIN
158: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the Calculation of Milestone Completion Date');
159:
160: IF (Use_Custom_Hook = 'Y') THEN
161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is ON');
162: l_Use_Custom_Hook := TRUE;
163: ELSE
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is OFF');
165: l_Use_Custom_Hook := FALSE;

Line 164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is OFF');

160: IF (Use_Custom_Hook = 'Y') THEN
161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is ON');
162: l_Use_Custom_Hook := TRUE;
163: ELSE
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter to Use Custom Code is OFF');
165: l_Use_Custom_Hook := FALSE;
166:
167: END IF;
168:

Line 172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Of Completion Date Calculation for Assignment '||l_Assignment_Number);

168:
169: FOR l_Assignment_list IN Get_Uncompleted_Assignments LOOP
170: l_Assignment_Number := l_Assignment_list.ASSIGNMENT_NUMBER;
171: l_Assignment_Id := l_Assignment_list.ASSIGNMENT_ID;
172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Of Completion Date Calculation for Assignment '||l_Assignment_Number);
173: FOR l_Assign_MS_Dtls IN Get_Uncompleted_System_MS LOOP
174: l_MS_Code := l_Assign_MS_Dtls.MILESTONE_CODE;
175:
176: IF (l_MS_Code = 'SOCREATE') THEN

Line 184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));

180: ELSE
181: L_Solicit_Creation_Dt := Get_Solicitation_Creation_Dt(l_Assignment_Number);
182: END IF;
183: IF (L_Solicit_Creation_Dt IS NOT NULL) THEN
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));
185: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
186: SET ACTUAL_COMPLETION_DATE = L_Solicit_Creation_Dt,
187: last_updated_by = fnd_global.user_id ,
188: last_update_date = SYSDATE ,

Line 193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' is not Completed');

189: last_update_login = fnd_global.login_id
190: WHERE ASSIGNMENT_ID = l_Assignment_Id
191: and MILESTONE_CODE = 'SOCREATE' ;
192: ELSE
193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' is not Completed');
194: END IF;
195: END IF;
196:
197: IF (l_MS_Code = 'SOPUBLIS') THEN

Line 204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Publish_Dt,'DD-MON-YYYY HH24:MI:SS'));

200: ELSE
201: L_Solicit_Publish_Dt := Get_Solicitation_Publish_Dt(l_Assignment_Number);
202: END IF;
203: IF (L_Solicit_Publish_Dt IS NOT NULL) THEN
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Publish_Dt,'DD-MON-YYYY HH24:MI:SS'));
205: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
206: SET ACTUAL_COMPLETION_DATE = L_Solicit_Publish_Dt,
207: last_updated_by = fnd_global.user_id ,
208: last_update_date = SYSDATE ,

Line 213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' is not Completed');

209: last_update_login = fnd_global.login_id
210: WHERE ASSIGNMENT_ID = l_Assignment_Id
211: and MILESTONE_CODE = 'SOPUBLIS' ;
212: ELSE
213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' is not Completed');
214: END IF;
215: END IF;
216:
217: IF (l_MS_Code = 'AWCREATE') THEN

Line 224: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));

220: ELSE
221: L_Award_Creation_Dt := Get_Award_Creation_Dt(l_Assignment_Number);
222: END IF;
223: IF (L_Award_Creation_Dt IS NOT NULL) THEN
224: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));
225: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
226: SET ACTUAL_COMPLETION_DATE = L_Award_Creation_Dt,
227: last_updated_by = fnd_global.user_id ,
228: last_update_date = SYSDATE ,

Line 234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Creation for Assignment'||l_Assignment_Number||' is not Completed');

230: WHERE ASSIGNMENT_ID = l_Assignment_Id
231: and MILESTONE_CODE = 'AWCREATE' ;
232:
233: ELSE
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Creation for Assignment'||l_Assignment_Number||' is not Completed');
235: END IF;
236: END IF;
237:
238: IF (l_MS_Code = 'AWAPPROV') THEN

Line 246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Approval_Dt,'DD-MON-YYYY HH24:MI:SS'));

242: L_Award_Approval_Dt := Get_Award_Approval_Dt(l_Assignment_Number);
243: END IF;
244:
245: IF (L_Award_Approval_Dt IS NOT NULL) THEN
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Approval_Dt,'DD-MON-YYYY HH24:MI:SS'));
247: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
248: SET ACTUAL_COMPLETION_DATE = L_Award_Approval_Dt,
249: last_updated_by = fnd_global.user_id ,
250: last_update_date = SYSDATE ,

Line 255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' is not Completed');

251: last_update_login = fnd_global.login_id
252: WHERE ASSIGNMENT_ID = l_Assignment_Id
253: and MILESTONE_CODE = 'AWAPPROV' ;
254: ELSE
255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' is not Completed');
256: END IF;
257: END IF;
258:
259: END LOOP;

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment '||l_Assignment_Number||' is Completed');

282: WHERE ASSIGNMENT_ID = l_Assignment_Id
283: and ACTUAL_COMPLETION_DATE is NULL ;
284:
285: IF (l_incomplete_MS_Count = 0) THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment '||l_Assignment_Number||' is Completed');
287: UPDATE PO_CLM_ASSIGNMENTS
288: SET ACTUAL_COMPLETION_DATE = (SELECT Max(ACTUAL_COMPLETION_DATE)
289: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
290: WHERE ASSIGNMENT_ID = l_Assignment_Id) ,