DBA Data[Home] [Help]

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on FND_MESSAGE

Line 35: -- which it cannot be retrieved using FND_MESSAGE.get

31: -- Desciption : Sets the message with tokens
32: -- Does NOT put the message on the message stack
33: -- This set_message is used instead of the standard OKL_API.set_message
34: -- because the OKL_API.set_message puts the message on message stack after
35: -- which it cannot be retrieved using FND_MESSAGE.get
36: -- Business Rules :
37: -- Parameters :
38: -- Version : 1.0
39: -- History : RMUNJULU created

Line 68: FND_MESSAGE.set_name( P_APP_NAME, P_MSG_NAME);

64: p_token10_value IN VARCHAR2 DEFAULT NULL ) IS
65:
66: BEGIN
67:
68: FND_MESSAGE.set_name( P_APP_NAME, P_MSG_NAME);
69:
70: IF (p_token1 IS NOT NULL) AND (p_token1_value IS NOT NULL) THEN
71: FND_MESSAGE.set_token( TOKEN => p_token1,
72: VALUE => p_token1_value);

Line 71: FND_MESSAGE.set_token( TOKEN => p_token1,

67:
68: FND_MESSAGE.set_name( P_APP_NAME, P_MSG_NAME);
69:
70: IF (p_token1 IS NOT NULL) AND (p_token1_value IS NOT NULL) THEN
71: FND_MESSAGE.set_token( TOKEN => p_token1,
72: VALUE => p_token1_value);
73: END IF;
74:
75: IF (p_token2 IS NOT NULL) AND (p_token2_value IS NOT NULL) THEN

Line 76: FND_MESSAGE.set_token( TOKEN => p_token2,

72: VALUE => p_token1_value);
73: END IF;
74:
75: IF (p_token2 IS NOT NULL) AND (p_token2_value IS NOT NULL) THEN
76: FND_MESSAGE.set_token( TOKEN => p_token2,
77: VALUE => p_token2_value);
78: END IF;
79:
80: IF (p_token3 IS NOT NULL) AND (p_token3_value IS NOT NULL) THEN

Line 81: FND_MESSAGE.set_token( TOKEN => p_token3,

77: VALUE => p_token2_value);
78: END IF;
79:
80: IF (p_token3 IS NOT NULL) AND (p_token3_value IS NOT NULL) THEN
81: FND_MESSAGE.set_token( TOKEN => p_token3,
82: VALUE => p_token3_value);
83: END IF;
84:
85: IF (p_token4 IS NOT NULL) AND (p_token4_value IS NOT NULL) THEN

Line 86: FND_MESSAGE.set_token( TOKEN => p_token4,

82: VALUE => p_token3_value);
83: END IF;
84:
85: IF (p_token4 IS NOT NULL) AND (p_token4_value IS NOT NULL) THEN
86: FND_MESSAGE.set_token( TOKEN => p_token4,
87: VALUE => p_token4_value);
88: END IF;
89:
90: IF (p_token5 IS NOT NULL) AND (p_token5_value IS NOT NULL) THEN

Line 91: FND_MESSAGE.set_token( TOKEN => p_token5,

87: VALUE => p_token4_value);
88: END IF;
89:
90: IF (p_token5 IS NOT NULL) AND (p_token5_value IS NOT NULL) THEN
91: FND_MESSAGE.set_token( TOKEN => p_token5,
92: VALUE => p_token5_value);
93: END IF;
94:
95: IF (p_token6 IS NOT NULL) AND (p_token6_value IS NOT NULL) THEN

Line 96: FND_MESSAGE.set_token( TOKEN => p_token6,

92: VALUE => p_token5_value);
93: END IF;
94:
95: IF (p_token6 IS NOT NULL) AND (p_token6_value IS NOT NULL) THEN
96: FND_MESSAGE.set_token( TOKEN => p_token6,
97: VALUE => p_token6_value);
98: END IF;
99: IF (p_token7 IS NOT NULL) AND (p_token7_value IS NOT NULL) THEN
100: FND_MESSAGE.set_token( TOKEN => p_token7,

Line 100: FND_MESSAGE.set_token( TOKEN => p_token7,

96: FND_MESSAGE.set_token( TOKEN => p_token6,
97: VALUE => p_token6_value);
98: END IF;
99: IF (p_token7 IS NOT NULL) AND (p_token7_value IS NOT NULL) THEN
100: FND_MESSAGE.set_token( TOKEN => p_token7,
101: VALUE => p_token7_value);
102: END IF;
103:
104: IF (p_token8 IS NOT NULL) AND (p_token8_value IS NOT NULL) THEN

Line 105: FND_MESSAGE.set_token( TOKEN => p_token8,

101: VALUE => p_token7_value);
102: END IF;
103:
104: IF (p_token8 IS NOT NULL) AND (p_token8_value IS NOT NULL) THEN
105: FND_MESSAGE.set_token( TOKEN => p_token8,
106: VALUE => p_token8_value);
107: END IF;
108: IF (p_token9 IS NOT NULL) AND (p_token9_value IS NOT NULL) THEN
109: FND_MESSAGE.set_token( TOKEN => p_token9,

Line 109: FND_MESSAGE.set_token( TOKEN => p_token9,

105: FND_MESSAGE.set_token( TOKEN => p_token8,
106: VALUE => p_token8_value);
107: END IF;
108: IF (p_token9 IS NOT NULL) AND (p_token9_value IS NOT NULL) THEN
109: FND_MESSAGE.set_token( TOKEN => p_token9,
110: VALUE => p_token9_value);
111: END IF;
112:
113: IF (p_token10 IS NOT NULL) AND (p_token10_value IS NOT NULL) THEN

Line 114: FND_MESSAGE.set_token( TOKEN => p_token10,

110: VALUE => p_token9_value);
111: END IF;
112:
113: IF (p_token10 IS NOT NULL) AND (p_token10_value IS NOT NULL) THEN
114: FND_MESSAGE.set_token( TOKEN => p_token10,
115: VALUE => p_token10_value);
116: END IF;
117:
118: --FND_MSG_PUB.add;

Line 236: l_noti_rec.success_main_body := FND_MESSAGE.get;

232: p_token2_value => l_term_date,
233: p_token3 => 'SERVICE_CONTRACT',
234: p_token3_value => l_oks_contract_number);
235:
236: l_noti_rec.success_main_body := FND_MESSAGE.get;
237:
238: -- Error Notifications main body
239: set_message(
240: p_app_name => G_APP_NAME,

Line 249: l_noti_rec.error_main_body := FND_MESSAGE.get;

245: p_token2_value => l_term_date,
246: p_token3 => 'SERVICE_CONTRACT',
247: p_token3_value => l_oks_contract_number);
248:
249: l_noti_rec.error_main_body := FND_MESSAGE.get;
250:
251: -- Termination Notifications main body
252: set_message(
253: p_app_name => G_APP_NAME,

Line 262: l_noti_rec.termination_main_body := FND_MESSAGE.get;

258: p_token2_value => l_term_date,
259: p_token3 => 'SERVICE_CONTRACT',
260: p_token3_value => l_oks_contract_number);
261:
262: l_noti_rec.termination_main_body := FND_MESSAGE.get;
263:
264: -- Return Notifications main body
265: set_message(
266: p_app_name => G_APP_NAME,

Line 273: l_noti_rec.return_main_body := FND_MESSAGE.get;

269: p_token1_value => l_oks_contract_number,
270: p_token2 => 'RETURN_DATE',
271: p_token2_value => l_return_date);
272:
273: l_noti_rec.return_main_body := FND_MESSAGE.get;
274:
275: -- Dispose Notifications main body
276: set_message(
277: p_app_name => G_APP_NAME,

Line 284: l_noti_rec.dispose_main_body := FND_MESSAGE.get;

280: p_token1_value => l_oks_contract_number,
281: p_token2 => 'DISPOSE_DATE',
282: p_token2_value => l_dispose_date);
283:
284: l_noti_rec.dispose_main_body := FND_MESSAGE.get;
285:
286: -- Dispose Notifications main body -- If Scrapped
287: set_message(
288: p_app_name => G_APP_NAME,

Line 295: l_noti_rec.scrap_main_body := FND_MESSAGE.get;

291: p_token1_value => l_oks_contract_number,
292: p_token2 => 'DISPOSE_DATE',
293: p_token2_value => l_dispose_date);
294:
295: l_noti_rec.scrap_main_body := FND_MESSAGE.get;
296:
297: -- Contract Details
298: set_message(
299: p_app_name => G_APP_NAME,

Line 302: l_noti_rec.contract_dtls := FND_MESSAGE.get;

298: set_message(
299: p_app_name => G_APP_NAME,
300: p_msg_name => 'OKL_AM_SRV_CONTRACT_DTLS');
301:
302: l_noti_rec.contract_dtls := FND_MESSAGE.get;
303:
304: -- Lease Contract
305: set_message(
306: p_app_name => G_APP_NAME,

Line 309: l_noti_rec.lease_contract := FND_MESSAGE.get;

305: set_message(
306: p_app_name => G_APP_NAME,
307: p_msg_name => 'OKL_AM_SRV_LEASE_CONTRACT');
308:
309: l_noti_rec.lease_contract := FND_MESSAGE.get;
310:
311: -- Service Contract
312: set_message(
313: p_app_name => G_APP_NAME,

Line 316: l_noti_rec.service_contract := FND_MESSAGE.get;

312: set_message(
313: p_app_name => G_APP_NAME,
314: p_msg_name => 'OKL_AM_SRV_SERVICE_CONTRACT');
315:
316: l_noti_rec.service_contract := FND_MESSAGE.get;
317:
318: -- Termination Date
319: set_message(
320: p_app_name => G_APP_NAME,

Line 323: l_noti_rec.termination_date := FND_MESSAGE.get;

319: set_message(
320: p_app_name => G_APP_NAME,
321: p_msg_name => 'OKL_AM_SRV_TERMINATION_DATE');
322:
323: l_noti_rec.termination_date := FND_MESSAGE.get;
324:
325: -- Asset Return Date
326: set_message(
327: p_app_name => G_APP_NAME,

Line 330: l_noti_rec.asset_ret_date := FND_MESSAGE.get;

326: set_message(
327: p_app_name => G_APP_NAME,
328: p_msg_name => 'OKL_AM_SRV_ASSET_RET_DATE');
329:
330: l_noti_rec.asset_ret_date := FND_MESSAGE.get;
331:
332: -- Asset Sale Date
333: set_message(
334: p_app_name => G_APP_NAME,

Line 337: l_noti_rec.asset_disp_date := FND_MESSAGE.get;

333: set_message(
334: p_app_name => G_APP_NAME,
335: p_msg_name => 'OKL_AM_SRV_ASSET_DISP_DATE');
336:
337: l_noti_rec.asset_disp_date := FND_MESSAGE.get;
338:
339: -- Schedule of Assets
340: set_message(
341: p_app_name => G_APP_NAME,

Line 344: l_noti_rec.schedule_assets := FND_MESSAGE.get;

340: set_message(
341: p_app_name => G_APP_NAME,
342: p_msg_name => 'OKL_AM_SRV_SCHEDULE_ASSETS');
343:
344: l_noti_rec.schedule_assets := FND_MESSAGE.get;
345:
346: -- Asset Number
347: set_message(
348: p_app_name => G_APP_NAME,

Line 351: l_noti_rec.asset_num := FND_MESSAGE.get;

347: set_message(
348: p_app_name => G_APP_NAME,
349: p_msg_name => 'OKL_AM_SRV_ASSET_NUM');
350:
351: l_noti_rec.asset_num := FND_MESSAGE.get;
352:
353: -- Item
354: set_message(
355: p_app_name => G_APP_NAME,

Line 358: l_noti_rec.item := FND_MESSAGE.get;

354: set_message(
355: p_app_name => G_APP_NAME,
356: p_msg_name => 'OKL_AM_SRV_ITEM');
357:
358: l_noti_rec.item := FND_MESSAGE.get;
359:
360: -- Description
361: set_message(
362: p_app_name => G_APP_NAME,

Line 365: l_noti_rec.item_description := FND_MESSAGE.get;

361: set_message(
362: p_app_name => G_APP_NAME,
363: p_msg_name => 'OKL_AM_SRV_ITEM_DESCRIPTION');
364:
365: l_noti_rec.item_description := FND_MESSAGE.get;
366:
367: -- Reference Number
368: set_message(
369: p_app_name => G_APP_NAME,

Line 372: l_noti_rec.reference_num := FND_MESSAGE.get;

368: set_message(
369: p_app_name => G_APP_NAME,
370: p_msg_name => 'OKL_AM_SRV_REFERENCE_NUM');
371:
372: l_noti_rec.reference_num := FND_MESSAGE.get;
373:
374: -- Serial Number
375: set_message(
376: p_app_name => G_APP_NAME,

Line 379: l_noti_rec.serial_num := FND_MESSAGE.get;

375: set_message(
376: p_app_name => G_APP_NAME,
377: p_msg_name => 'OKL_AM_SRV_SERIAL_NUM');
378:
379: l_noti_rec.serial_num := FND_MESSAGE.get;
380:
381: -- Quantity
382: set_message(
383: p_app_name => G_APP_NAME,

Line 386: l_noti_rec.quantity := FND_MESSAGE.get;

382: set_message(
383: p_app_name => G_APP_NAME,
384: p_msg_name => 'OKL_AM_SRV_QUANTITY');
385:
386: l_noti_rec.quantity := FND_MESSAGE.get;
387:
388: -- Body End
389: set_message(
390: p_app_name => G_APP_NAME,

Line 393: l_noti_rec.body_end := FND_MESSAGE.get;

389: set_message(
390: p_app_name => G_APP_NAME,
391: p_msg_name => 'OKL_AM_SRV_BODY_END');
392:
393: l_noti_rec.body_end := FND_MESSAGE.get;
394:
395: -- ********
396: -- Set the out parameter
397: -- ********

Line 742: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

738: l_parameter_list.DELETE;
739:
740: EXCEPTION
741: WHEN OTHERS THEN
742: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
744: FND_MSG_PUB.ADD;
745: IF okl_key_csr%ISOPEN THEN
746: CLOSE okl_key_csr;

Line 743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

739:
740: EXCEPTION
741: WHEN OTHERS THEN
742: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
744: FND_MSG_PUB.ADD;
745: IF okl_key_csr%ISOPEN THEN
746: CLOSE okl_key_csr;
747: END IF;

Line 916: l_message_subject := FND_MESSAGE.get;

912: set_message(
913: p_app_name => G_APP_NAME,
914: p_msg_name => 'OKL_AM_SRV_SUCCESS_MSG_SUB');
915:
916: l_message_subject := FND_MESSAGE.get;
917:
918: ELSIF l_source = 'ERROR' THEN
919:
920: -- Error Message Subject

Line 925: l_message_subject := FND_MESSAGE.get;

921: set_message(
922: p_app_name => G_APP_NAME,
923: p_msg_name => 'OKL_AM_SRV_ERROR_MSG_SUB');
924:
925: l_message_subject := FND_MESSAGE.get;
926:
927: ELSIF l_source = 'TERMINATION' THEN
928:
929: -- Termination Message Subject

Line 934: l_message_subject := FND_MESSAGE.get;

930: set_message(
931: p_app_name => G_APP_NAME,
932: p_msg_name => 'OKL_AM_SRV_TERM_MSG_SUB');
933:
934: l_message_subject := FND_MESSAGE.get;
935:
936: END IF;
937:
938: ELSIF l_source = 'DISPOSE' THEN

Line 960: l_message_subject := FND_MESSAGE.get;

956: set_message(
957: p_app_name => G_APP_NAME,
958: p_msg_name => 'OKL_AM_SRV_SCRAP_MSG_SUB');
959:
960: l_message_subject := FND_MESSAGE.get;
961:
962: ELSE
963:
964: -- Dispose Message Subject

Line 969: l_message_subject := FND_MESSAGE.get;

965: set_message(
966: p_app_name => G_APP_NAME,
967: p_msg_name => 'OKL_AM_SRV_DISPOSE_MSG_SUB');
968:
969: l_message_subject := FND_MESSAGE.get;
970: END IF;
971: ELSIF l_source = 'RETURN' THEN
972:
973: -- Trn_Id is Asset_Id

Line 989: l_message_subject := FND_MESSAGE.get;

985: set_message(
986: p_app_name => G_APP_NAME,
987: p_msg_name => 'OKL_AM_SRV_RETURN_MSG_SUB');
988:
989: l_message_subject := FND_MESSAGE.get;
990:
991: END IF;
992:
993: -- get okl contract dtls