APPS.CS_KB_SOLN_IN_PROGRESS_PKG dependencies on FND_FILE

Line 30: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting Concurrent Program to unlock Solutions at: '||sysdate);

26: l_login NUMBER := FND_GLOBAL.Login_Id;
27:
28: BEGIN
29:
30: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting Concurrent Program to unlock Solutions at: '||sysdate);
31:
32: /*
33: FND_FILE.PUT_LINE(FND_FILE.LOG,
34: 'Solutions will be unlocked if the locking User nolonger has access

Line 33: FND_FILE.PUT_LINE(FND_FILE.LOG,

29:
30: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting Concurrent Program to unlock Solutions at: '||sysdate);
31:
32: /*
33: FND_FILE.PUT_LINE(FND_FILE.LOG,
34: 'Solutions will be unlocked if the locking User nolonger has access
35: to the complete Solution. Access to the complete solution invloves
36: the User having the necessary Visibility to the Solution and all its
37: associated statements. The Solution must also reside in a Category

Line 39: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

35: to the complete Solution. Access to the complete solution invloves
36: the User having the necessary Visibility to the Solution and all its
37: associated statements. The Solution must also reside in a Category
38: that has been associated to the users Category Group. ');
39: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
40: */
41:
42: FOR Solutions IN GET_IN_PROGRESS_SOLUTIONS LOOP
43:

Line 70: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_NOT_RESEND_ERR')||

66: p_flow_details_id => Solutions.FLow_Details_Id,
67: p_group_id => Solutions.Group_Id,
68: p_solution_title => Solutions.Name );
69: EXCEPTION WHEN OTHERS THEN
70: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_NOT_RESEND_ERR')||
71: Solutions.Set_Number||' -'||substrb(sqlerrm,1,200));
72: END;
73:
74: END IF;

Line 76: FND_FILE.PUT_LINE(FND_FILE.LOG, Solutions.Set_Number||fnd_message.GET_STRING('CS','CS_KB_SOLN_UNLOCK'));

72: END;
73:
74: END IF;
75:
76: FND_FILE.PUT_LINE(FND_FILE.LOG, Solutions.Set_Number||fnd_message.GET_STRING('CS','CS_KB_SOLN_UNLOCK'));
77:
78: END IF;
79:
80: END LOOP;

Line 82: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished Concurrent Program to unlock Solutions at: '||sysdate);

78: END IF;
79:
80: END LOOP;
81:
82: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished Concurrent Program to unlock Solutions at: '||sysdate);
83:
84: COMMIT;
85:
86: --ERRBUF := 'Success';

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

93:
94: RETCODE := 2;
95:
96: ERRBUF := fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
97: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
98:
99: END CHECK_SOLN_IN_PROGRESS;
100:
101: END CS_KB_SOLN_IN_PROGRESS_PKG;