6: p_msg_type IN VARCHAR2 := 'PV_DEBUG_MESSAGE'
7: )
8: IS
9: BEGIN
10: FND_MESSAGE.Set_Name('PV', p_msg_type);
11: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
12:
13: IF (g_log_to_file = 'N') THEN
14: FND_MSG_PUB.Add;
7: )
8: IS
9: BEGIN
10: FND_MESSAGE.Set_Name('PV', p_msg_type);
11: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
12:
13: IF (g_log_to_file = 'N') THEN
14: FND_MSG_PUB.Add;
15:
13: IF (g_log_to_file = 'N') THEN
14: FND_MSG_PUB.Add;
15:
16: ELSIF (g_log_to_file = 'Y') THEN
17: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
18: END IF;
19: END Debug;
20:
21:
207:
208: -- -----------------------------------------------------------------------
209: -- Start time message...
210: -- -----------------------------------------------------------------------
211: FND_MESSAGE.SET_NAME(application => 'PV',
212: name => 'PV_CREATE_CONTEXT_START_TIME');
213: FND_MESSAGE.SET_TOKEN(token => 'P_DATE_TIME',
214: value => TO_CHAR(l_run_date, 'DD-MON-YYYY HH24:MI:SS') );
215:
209: -- Start time message...
210: -- -----------------------------------------------------------------------
211: FND_MESSAGE.SET_NAME(application => 'PV',
212: name => 'PV_CREATE_CONTEXT_START_TIME');
213: FND_MESSAGE.SET_TOKEN(token => 'P_DATE_TIME',
214: value => TO_CHAR(l_run_date, 'DD-MON-YYYY HH24:MI:SS') );
215:
216: IF (g_log_to_file = 'Y') THEN
217: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
213: FND_MESSAGE.SET_TOKEN(token => 'P_DATE_TIME',
214: value => TO_CHAR(l_run_date, 'DD-MON-YYYY HH24:MI:SS') );
215:
216: IF (g_log_to_file = 'Y') THEN
217: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
218: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
219: ELSE
220: FND_MSG_PUB.Add;
221: END IF;
551: END LOOP;
552:
553: end if;
554:
555: FND_MESSAGE.SET_NAME( application => 'PV' ,name => 'PV_CREATE_CONTEXT_END_TIME');
556: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
557: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
558:
559: IF (g_log_to_file = 'Y') THEN
552:
553: end if;
554:
555: FND_MESSAGE.SET_NAME( application => 'PV' ,name => 'PV_CREATE_CONTEXT_END_TIME');
556: FND_MESSAGE.SET_TOKEN( token => 'P_DATE_TIME'
557: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
558:
559: IF (g_log_to_file = 'Y') THEN
560: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
557: ,value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
558:
559: IF (g_log_to_file = 'Y') THEN
560: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
561: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
562: ELSE
563: FND_MSG_PUB.Add;
564: END IF;
565: