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.XNP_UTILS dependencies on FND_MESSAGE

Line 272: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');

268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: -- Grab the error message and error no.
272: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');
273: fnd_message.set_token('PORTING_ID',l_porting_id);
274: l_error_desc := fnd_message.get;
275:
276:

Line 273: fnd_message.set_token('PORTING_ID',l_porting_id);

269: EXCEPTION
270: WHEN OTHERS THEN
271: -- Grab the error message and error no.
272: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');
273: fnd_message.set_token('PORTING_ID',l_porting_id);
274: l_error_desc := fnd_message.get;
275:
276:
277: x_RETURN_CODE := SQLCODE;

Line 274: l_error_desc := fnd_message.get;

270: WHEN OTHERS THEN
271: -- Grab the error message and error no.
272: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');
273: fnd_message.set_token('PORTING_ID',l_porting_id);
274: l_error_desc := fnd_message.get;
275:
276:
277: x_RETURN_CODE := SQLCODE;
278: x_ERROR_DESCRIPTION := SQLERRM||l_error_desc;

Line 350: fnd_message.set_name('XNP','GET_ORIG_DONOR_FE_ERR_REASON');

346:
347: EXCEPTION
348: WHEN OTHERS THEN
349: -- Grab the error message and error no.
350: fnd_message.set_name('XNP','GET_ORIG_DONOR_FE_ERR_REASON');
351: l_error_description := fnd_message.get;
352:
353: x_RETURN_CODE := SQLCODE;
354: x_ERROR_DESCRIPTION := SQLERRM||l_error_description;

Line 351: l_error_description := fnd_message.get;

347: EXCEPTION
348: WHEN OTHERS THEN
349: -- Grab the error message and error no.
350: fnd_message.set_name('XNP','GET_ORIG_DONOR_FE_ERR_REASON');
351: l_error_description := fnd_message.get;
352:
353: x_RETURN_CODE := SQLCODE;
354: x_ERROR_DESCRIPTION := SQLERRM||l_error_description;
355:

Line 423: fnd_message.set_name('XNP','GET_NRC_FE_ERR_REASON');

419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: -- Grab the error message and error no.
423: fnd_message.set_name('XNP','GET_NRC_FE_ERR_REASON');
424: l_error_description := fnd_message.get;
425:
426: x_RETURN_CODE := SQLCODE;
427: x_ERROR_DESCRIPTION := SQLERRM||l_error_description;

Line 424: l_error_description := fnd_message.get;

420: EXCEPTION
421: WHEN OTHERS THEN
422: -- Grab the error message and error no.
423: fnd_message.set_name('XNP','GET_NRC_FE_ERR_REASON');
424: l_error_description := fnd_message.get;
425:
426: x_RETURN_CODE := SQLCODE;
427: x_ERROR_DESCRIPTION := SQLERRM||l_error_description;
428:

Line 509: fnd_message.set_name('XNP','GET_RECIPIENT_FE_ERR_REASON');

505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: -- Grab the error message and error no.
509: fnd_message.set_name('XNP','GET_RECIPIENT_FE_ERR_REASON');
510: fnd_message.set_token('PORTING_ID',l_porting_id);
511: l_error_description := fnd_message.get;
512:
513: x_RETURN_CODE := SQLCODE;

Line 510: fnd_message.set_token('PORTING_ID',l_porting_id);

506: EXCEPTION
507: WHEN OTHERS THEN
508: -- Grab the error message and error no.
509: fnd_message.set_name('XNP','GET_RECIPIENT_FE_ERR_REASON');
510: fnd_message.set_token('PORTING_ID',l_porting_id);
511: l_error_description := fnd_message.get;
512:
513: x_RETURN_CODE := SQLCODE;
514: x_ERROR_DESCRIPTION := SQLERRM||l_error_description;

Line 511: l_error_description := fnd_message.get;

507: WHEN OTHERS THEN
508: -- Grab the error message and error no.
509: fnd_message.set_name('XNP','GET_RECIPIENT_FE_ERR_REASON');
510: fnd_message.set_token('PORTING_ID',l_porting_id);
511: l_error_description := fnd_message.get;
512:
513: x_RETURN_CODE := SQLCODE;
514: x_ERROR_DESCRIPTION := SQLERRM||l_error_description;
515:

Line 574: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');

570:
571: EXCEPTION
572: when others then
573: x_return_code := SQLCODE;
574: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
575: fnd_message.set_token('PARAM_NAME','Get_Sender_Fe:SENDER_NAME');
576:
577: x_error_description := SQLERRM||' : '||fnd_message.get;
578:

Line 575: fnd_message.set_token('PARAM_NAME','Get_Sender_Fe:SENDER_NAME');

571: EXCEPTION
572: when others then
573: x_return_code := SQLCODE;
574: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
575: fnd_message.set_token('PARAM_NAME','Get_Sender_Fe:SENDER_NAME');
576:
577: x_error_description := SQLERRM||' : '||fnd_message.get;
578:
579: END GET_SENDER_FE;

Line 577: x_error_description := SQLERRM||' : '||fnd_message.get;

573: x_return_code := SQLCODE;
574: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
575: fnd_message.set_token('PARAM_NAME','Get_Sender_Fe:SENDER_NAME');
576:
577: x_error_description := SQLERRM||' : '||fnd_message.get;
578:
579: END GET_SENDER_FE;
580:
581:

Line 714: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');

710:
711: exception
712: when others then
713: x_return_code := SQLCODE;
714: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
715: fnd_message.set_token('PARAM_NAME','DONOR_SP_ID');
716:
717: x_error_description := SQLERRM||' : '||fnd_message.get;
718:

Line 715: fnd_message.set_token('PARAM_NAME','DONOR_SP_ID');

711: exception
712: when others then
713: x_return_code := SQLCODE;
714: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
715: fnd_message.set_token('PARAM_NAME','DONOR_SP_ID');
716:
717: x_error_description := SQLERRM||' : '||fnd_message.get;
718:
719: END GET_DONOR_NAME;

Line 717: x_error_description := SQLERRM||' : '||fnd_message.get;

713: x_return_code := SQLCODE;
714: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
715: fnd_message.set_token('PARAM_NAME','DONOR_SP_ID');
716:
717: x_error_description := SQLERRM||' : '||fnd_message.get;
718:
719: END GET_DONOR_NAME;
720:
721: --------------------------------------------------------------------

Line 745: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');

741:
742: exception
743: when others then
744: x_return_code := SQLCODE;
745: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
746: fnd_message.set_token('PARAM_NAME','SENDER_NAME');
747:
748: x_error_description := SQLERRM||' : '||fnd_message.get;
749:

Line 746: fnd_message.set_token('PARAM_NAME','SENDER_NAME');

742: exception
743: when others then
744: x_return_code := SQLCODE;
745: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
746: fnd_message.set_token('PARAM_NAME','SENDER_NAME');
747:
748: x_error_description := SQLERRM||' : '||fnd_message.get;
749:
750:

Line 748: x_error_description := SQLERRM||' : '||fnd_message.get;

744: x_return_code := SQLCODE;
745: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
746: fnd_message.set_token('PARAM_NAME','SENDER_NAME');
747:
748: x_error_description := SQLERRM||' : '||fnd_message.get;
749:
750:
751: END GET_SENDER_NAME;
752:

Line 805: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');

801: );
802: exception
803: when others then
804: x_return_code := SQLCODE;
805: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
806: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');
807:
808: x_error_description := SQLERRM||' : '||fnd_message.get;
809:

Line 806: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');

802: exception
803: when others then
804: x_return_code := SQLCODE;
805: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
806: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');
807:
808: x_error_description := SQLERRM||' : '||fnd_message.get;
809:
810: END GET_ORIG_DONOR_NAME;

Line 808: x_error_description := SQLERRM||' : '||fnd_message.get;

804: x_return_code := SQLCODE;
805: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
806: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');
807:
808: x_error_description := SQLERRM||' : '||fnd_message.get;
809:
810: END GET_ORIG_DONOR_NAME;
811:
812: --------------------------------------------------------------------

Line 868: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');

864:
865: exception
866: when others then
867: x_return_code := SQLCODE;
868: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
869: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');
870:
871: x_error_description := SQLERRM||' : '||fnd_message.get;
872:

Line 869: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');

865: exception
866: when others then
867: x_return_code := SQLCODE;
868: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
869: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');
870:
871: x_error_description := SQLERRM||' : '||fnd_message.get;
872:
873: END GET_NRC_NAME;

Line 871: x_error_description := SQLERRM||' : '||fnd_message.get;

867: x_return_code := SQLCODE;
868: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
869: fnd_message.set_token('PARAM_NAME','STARTING_NUMBER/ENDING_NUMBER');
870:
871: x_error_description := SQLERRM||' : '||fnd_message.get;
872:
873: END GET_NRC_NAME;
874:
875:

Line 898: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');

894: );
895: exception
896: when others then
897: x_return_code := SQLCODE;
898: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
899: fnd_message.set_token('PARAM_NAME','RECIPIENT_SP_ID');
900: x_error_description := SQLERRM||' : '||fnd_message.get;
901:
902:

Line 899: fnd_message.set_token('PARAM_NAME','RECIPIENT_SP_ID');

895: exception
896: when others then
897: x_return_code := SQLCODE;
898: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
899: fnd_message.set_token('PARAM_NAME','RECIPIENT_SP_ID');
900: x_error_description := SQLERRM||' : '||fnd_message.get;
901:
902:
903: END GET_RECIPIENT_NAME;

Line 900: x_error_description := SQLERRM||' : '||fnd_message.get;

896: when others then
897: x_return_code := SQLCODE;
898: fnd_message.set_name('XNP','GET_NAME_ERR_REASON');
899: fnd_message.set_token('PARAM_NAME','RECIPIENT_SP_ID');
900: x_error_description := SQLERRM||' : '||fnd_message.get;
901:
902:
903: END GET_RECIPIENT_NAME;
904:

Line 929: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');

925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: x_error_code := SQLCODE;
929: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');
930: fnd_message.set_token('FE_ID',to_char(p_fe_id));
931:
932: x_error_message := SQLERRM||':'|| fnd_message.get;
933:

Line 930: fnd_message.set_token('FE_ID',to_char(p_fe_id));

926: EXCEPTION
927: WHEN OTHERS THEN
928: x_error_code := SQLCODE;
929: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');
930: fnd_message.set_token('FE_ID',to_char(p_fe_id));
931:
932: x_error_message := SQLERRM||':'|| fnd_message.get;
933:
934: IF get_fe_name_for_fe_id%ISOPEN THEN

Line 932: x_error_message := SQLERRM||':'|| fnd_message.get;

928: x_error_code := SQLCODE;
929: fnd_message.set_name('XNP','GET_DONOR_FE_ERR_REASON');
930: fnd_message.set_token('FE_ID',to_char(p_fe_id));
931:
932: x_error_message := SQLERRM||':'|| fnd_message.get;
933:
934: IF get_fe_name_for_fe_id%ISOPEN THEN
935: close get_fe_name_for_fe_id ;
936: END IF ;

Line 977: fnd_message.set_name('XNP','NO_FE_FOR_SP');

973:
974:
975: IF g_get_fe_name_for_sp_csr%NOTFOUND THEN
976: x_error_code := xnp_errors.g_no_fe_for_sp;
977: fnd_message.set_name('XNP','NO_FE_FOR_SP');
978: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
979: x_error_message := fnd_message.get;
980: CLOSE g_get_fe_name_for_sp_csr ;
981: RETURN ;

Line 978: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));

974:
975: IF g_get_fe_name_for_sp_csr%NOTFOUND THEN
976: x_error_code := xnp_errors.g_no_fe_for_sp;
977: fnd_message.set_name('XNP','NO_FE_FOR_SP');
978: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
979: x_error_message := fnd_message.get;
980: CLOSE g_get_fe_name_for_sp_csr ;
981: RETURN ;
982:

Line 979: x_error_message := fnd_message.get;

975: IF g_get_fe_name_for_sp_csr%NOTFOUND THEN
976: x_error_code := xnp_errors.g_no_fe_for_sp;
977: fnd_message.set_name('XNP','NO_FE_FOR_SP');
978: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
979: x_error_message := fnd_message.get;
980: CLOSE g_get_fe_name_for_sp_csr ;
981: RETURN ;
982:
983: END IF;

Line 988: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');

984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: x_error_code := SQLCODE;
988: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
989: fnd_message.set_token('SP_ID',p_sp_id);
990:
991: x_error_message := SQLERRM||':'||fnd_message.get;
992:

Line 989: fnd_message.set_token('SP_ID',p_sp_id);

985: EXCEPTION
986: WHEN OTHERS THEN
987: x_error_code := SQLCODE;
988: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
989: fnd_message.set_token('SP_ID',p_sp_id);
990:
991: x_error_message := SQLERRM||':'||fnd_message.get;
992:
993: IF g_get_fe_name_for_sp_csr%ISOPEN THEN

Line 991: x_error_message := SQLERRM||':'||fnd_message.get;

987: x_error_code := SQLCODE;
988: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
989: fnd_message.set_token('SP_ID',p_sp_id);
990:
991: x_error_message := SQLERRM||':'||fnd_message.get;
992:
993: IF g_get_fe_name_for_sp_csr%ISOPEN THEN
994: close g_get_fe_name_for_sp_csr ;
995: END IF ;

Line 1030: fnd_message.set_name('XNP','NO_FE_FOR_SP');

1026: FETCH g_get_fe_name_for_sp_csr INTO x_FE_NAME ;
1027:
1028: IF g_get_fe_name_for_sp_csr%NOTFOUND THEN
1029: x_error_code := xnp_errors.g_no_fe_for_sp;
1030: fnd_message.set_name('XNP','NO_FE_FOR_SP');
1031: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
1032: x_error_message := fnd_message.get;
1033: CLOSE g_get_fe_name_for_sp_csr ;
1034: RETURN ;

Line 1031: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));

1027:
1028: IF g_get_fe_name_for_sp_csr%NOTFOUND THEN
1029: x_error_code := xnp_errors.g_no_fe_for_sp;
1030: fnd_message.set_name('XNP','NO_FE_FOR_SP');
1031: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
1032: x_error_message := fnd_message.get;
1033: CLOSE g_get_fe_name_for_sp_csr ;
1034: RETURN ;
1035:

Line 1032: x_error_message := fnd_message.get;

1028: IF g_get_fe_name_for_sp_csr%NOTFOUND THEN
1029: x_error_code := xnp_errors.g_no_fe_for_sp;
1030: fnd_message.set_name('XNP','NO_FE_FOR_SP');
1031: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
1032: x_error_message := fnd_message.get;
1033: CLOSE g_get_fe_name_for_sp_csr ;
1034: RETURN ;
1035:
1036: END IF;

Line 1043: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');

1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: x_error_code := SQLCODE;
1043: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
1044: fnd_message.set_token('SP_ID',p_sp_id);
1045:
1046: x_error_message := SQLERRM||':'||fnd_message.get;
1047:

Line 1044: fnd_message.set_token('SP_ID',p_sp_id);

1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: x_error_code := SQLCODE;
1043: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
1044: fnd_message.set_token('SP_ID',p_sp_id);
1045:
1046: x_error_message := SQLERRM||':'||fnd_message.get;
1047:
1048: IF g_get_fe_name_for_sp_csr%ISOPEN THEN

Line 1046: x_error_message := SQLERRM||':'||fnd_message.get;

1042: x_error_code := SQLCODE;
1043: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
1044: fnd_message.set_token('SP_ID',p_sp_id);
1045:
1046: x_error_message := SQLERRM||':'||fnd_message.get;
1047:
1048: IF g_get_fe_name_for_sp_csr%ISOPEN THEN
1049: close g_get_fe_name_for_sp_csr ;
1050: END IF ;

Line 1202: fnd_message.set_name('XNP',p_msg_name);

1198: l_progress VARCHAR2(4000) := NULL;
1199: l_STARTING_NUMBER VARCHAR2(40) := NULL;
1200: l_ENDING_NUMBER VARCHAR2(40) := NULL;
1201: BEGIN
1202: fnd_message.set_name('XNP',p_msg_name);
1203:
1204: l_STARTING_NUMBER :=
1205: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1206: (P_WORKITEM_INSTANCE_ID

Line 1215: fnd_message.set_token('NUMRANGE'

1211: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1212: (P_WORKITEM_INSTANCE_ID
1213: ,'ENDING_NUMBER'
1214: );
1215: fnd_message.set_token('NUMRANGE'
1216: , l_STARTING_NUMBER||' to ' || l_ENDING_NUMBER);
1217:
1218: if (p_tok1 IS NOT NULL) then
1219: fnd_message.set_token(p_tok1, p_val1);

Line 1219: fnd_message.set_token(p_tok1, p_val1);

1215: fnd_message.set_token('NUMRANGE'
1216: , l_STARTING_NUMBER||' to ' || l_ENDING_NUMBER);
1217:
1218: if (p_tok1 IS NOT NULL) then
1219: fnd_message.set_token(p_tok1, p_val1);
1220: end if;
1221:
1222: if (p_tok2 IS NOT NULL) then
1223: fnd_message.set_token(p_tok2, p_val2);

Line 1223: fnd_message.set_token(p_tok2, p_val2);

1219: fnd_message.set_token(p_tok1, p_val1);
1220: end if;
1221:
1222: if (p_tok2 IS NOT NULL) then
1223: fnd_message.set_token(p_tok2, p_val2);
1224: end if;
1225:
1226: if (p_tok3 IS NOT NULL) then
1227: fnd_message.set_token(p_tok3, p_val3);

Line 1227: fnd_message.set_token(p_tok3, p_val3);

1223: fnd_message.set_token(p_tok2, p_val2);
1224: end if;
1225:
1226: if (p_tok3 IS NOT NULL) then
1227: fnd_message.set_token(p_tok3, p_val3);
1228: end if;
1229:
1230:
1231: l_progress := '$' || fnd_message.get;

Line 1231: l_progress := '$' || fnd_message.get;

1227: fnd_message.set_token(p_tok3, p_val3);
1228: end if;
1229:
1230:
1231: l_progress := '$' || fnd_message.get;
1232:
1233: wf_core.context( p_pkg_name
1234: , p_proc_name
1235: , l_progress

Line 1337: fnd_message.set_name('XNP','STD_GET_FAILED');

1333:
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: x_error_code := SQLCODE;
1337: fnd_message.set_name('XNP','STD_GET_FAILED');
1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);

Line 1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');

1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: x_error_code := SQLCODE;
1337: fnd_message.set_name('XNP','STD_GET_FAILED');
1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);
1342: x_error_message := fnd_message.get||':'||SQLERRM;

Line 1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');

1335: WHEN NO_DATA_FOUND THEN
1336: x_error_code := SQLCODE;
1337: fnd_message.set_name('XNP','STD_GET_FAILED');
1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);
1342: x_error_message := fnd_message.get||':'||SQLERRM;
1343:

Line 1340: fnd_message.set_token('KEY','REFERENCE_ID');

1336: x_error_code := SQLCODE;
1337: fnd_message.set_name('XNP','STD_GET_FAILED');
1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);
1342: x_error_message := fnd_message.get||':'||SQLERRM;
1343:
1344: IF c_get_process_reference%ISOPEN THEN

Line 1341: fnd_message.set_token('VALUE',p_reference_id);

1337: fnd_message.set_name('XNP','STD_GET_FAILED');
1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);
1342: x_error_message := fnd_message.get||':'||SQLERRM;
1343:
1344: IF c_get_process_reference%ISOPEN THEN
1345: close c_get_process_reference;

Line 1342: x_error_message := fnd_message.get||':'||SQLERRM;

1338: fnd_message.set_token('FAILED_PROC','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1339: fnd_message.set_token('ATTRNAME','PROCESS_REFERENCE');
1340: fnd_message.set_token('KEY','REFERENCE_ID');
1341: fnd_message.set_token('VALUE',p_reference_id);
1342: x_error_message := fnd_message.get||':'||SQLERRM;
1343:
1344: IF c_get_process_reference%ISOPEN THEN
1345: close c_get_process_reference;
1346: END IF;

Line 1350: fnd_message.set_name('XNP','STD_ERROR');

1346: END IF;
1347:
1348: WHEN OTHERS THEN
1349: x_error_code := SQLCODE;
1350: fnd_message.set_name('XNP','STD_ERROR');
1351: fnd_message.set_token('ERROR_LOCN','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1353: x_error_message := fnd_message.get;
1354:

Line 1351: fnd_message.set_token('ERROR_LOCN','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');

1347:
1348: WHEN OTHERS THEN
1349: x_error_code := SQLCODE;
1350: fnd_message.set_name('XNP','STD_ERROR');
1351: fnd_message.set_token('ERROR_LOCN','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1353: x_error_message := fnd_message.get;
1354:
1355: IF c_get_process_reference%ISOPEN THEN

Line 1352: fnd_message.set_token('ERROR_TEXT',SQLERRM);

1348: WHEN OTHERS THEN
1349: x_error_code := SQLCODE;
1350: fnd_message.set_name('XNP','STD_ERROR');
1351: fnd_message.set_token('ERROR_LOCN','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1353: x_error_message := fnd_message.get;
1354:
1355: IF c_get_process_reference%ISOPEN THEN
1356: close c_get_process_reference;

Line 1353: x_error_message := fnd_message.get;

1349: x_error_code := SQLCODE;
1350: fnd_message.set_name('XNP','STD_ERROR');
1351: fnd_message.set_token('ERROR_LOCN','XNP_UTILS.GET_WORKITEM_INSTANCE_ID');
1352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1353: x_error_message := fnd_message.get;
1354:
1355: IF c_get_process_reference%ISOPEN THEN
1356: close c_get_process_reference;
1357: END IF;

Line 1530: l_string := fnd_message.get_string(l_appln_name,p_mls_message_name);

1526: x_error_message := null;
1527:
1528: -- Get the string to be parsed and decoded
1529: l_appln_name := substr(p_mls_message_name,1,3);
1530: l_string := fnd_message.get_string(l_appln_name,p_mls_message_name);
1531:
1532: fnd_message.set_name(l_appln_name,p_mls_message_name);
1533:
1534: -- ensure that there is a space before each '&'

Line 1532: fnd_message.set_name(l_appln_name,p_mls_message_name);

1528: -- Get the string to be parsed and decoded
1529: l_appln_name := substr(p_mls_message_name,1,3);
1530: l_string := fnd_message.get_string(l_appln_name,p_mls_message_name);
1531:
1532: fnd_message.set_name(l_appln_name,p_mls_message_name);
1533:
1534: -- ensure that there is a space before each '&'
1535: -- and space after the message string
1536: l_string := replace(l_string,'&',' &');

Line 1571: fnd_message.set_token(token,nvl(l_value,''));

1567: (p_workitem_instance_id
1568: ,token
1569: );
1570:
1571: fnd_message.set_token(token,nvl(l_value,''));
1572:
1573: l_string := substr(l_string,instr(l_string,token),l_length);
1574:
1575: EXIT WHEN ((length(l_string) = 0) OR (l_string is null ));

Line 1578: l_body := fnd_message.get;

1574:
1575: EXIT WHEN ((length(l_string) = 0) OR (l_string is null ));
1576: END LOOP;
1577:
1578: l_body := fnd_message.get;
1579: x_body := l_body;
1580: x_subject := substr(l_body,1,instr(l_body,xnp_utils.g_new_line));
1581: return;
1582:

Line 1618: fnd_message.set_name('XNP','NO_FE_FOR_SP');

1614:
1615: IF get_fe_name_for_sp1%NOTFOUND THEN
1616:
1617: x_error_code := xnp_errors.g_no_fe_for_sp;
1618: fnd_message.set_name('XNP','NO_FE_FOR_SP');
1619: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
1620: x_error_message := fnd_message.get;
1621: CLOSE get_fe_name_for_sp1 ;
1622: RETURN ;

Line 1619: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));

1615: IF get_fe_name_for_sp1%NOTFOUND THEN
1616:
1617: x_error_code := xnp_errors.g_no_fe_for_sp;
1618: fnd_message.set_name('XNP','NO_FE_FOR_SP');
1619: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
1620: x_error_message := fnd_message.get;
1621: CLOSE get_fe_name_for_sp1 ;
1622: RETURN ;
1623:

Line 1620: x_error_message := fnd_message.get;

1616:
1617: x_error_code := xnp_errors.g_no_fe_for_sp;
1618: fnd_message.set_name('XNP','NO_FE_FOR_SP');
1619: fnd_message.set_token('NAME', TO_CHAR(p_sp_id));
1620: x_error_message := fnd_message.get;
1621: CLOSE get_fe_name_for_sp1 ;
1622: RETURN ;
1623:
1624: END IF;

Line 1635: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');

1631: EXCEPTION
1632: WHEN OTHERS THEN
1633:
1634: x_error_code := SQLCODE;
1635: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
1636: fnd_message.set_token('SP_ID',p_sp_id);
1637: x_error_message := SQLERRM||':'||fnd_message.get;
1638:
1639: IF get_fe_name_for_sp1%ISOPEN THEN

Line 1636: fnd_message.set_token('SP_ID',p_sp_id);

1632: WHEN OTHERS THEN
1633:
1634: x_error_code := SQLCODE;
1635: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
1636: fnd_message.set_token('SP_ID',p_sp_id);
1637: x_error_message := SQLERRM||':'||fnd_message.get;
1638:
1639: IF get_fe_name_for_sp1%ISOPEN THEN
1640: close get_fe_name_for_sp1 ;

Line 1637: x_error_message := SQLERRM||':'||fnd_message.get;

1633:
1634: x_error_code := SQLCODE;
1635: fnd_message.set_name('XNP','GET_FE_NAME_FOR_SP_ERR_REASON');
1636: fnd_message.set_token('SP_ID',p_sp_id);
1637: x_error_message := SQLERRM||':'||fnd_message.get;
1638:
1639: IF get_fe_name_for_sp1%ISOPEN THEN
1640: close get_fe_name_for_sp1 ;
1641: END IF ;

Line 1744: fnd_message.set_name('XNP','XNP_NUM_RANGE_EXISTS');

1740:
1741: IF ( (l_number_range_id is not null)
1742: AND (l_number_range_id <> nvl(p_number_range_id,-1)) )
1743: THEN
1744: fnd_message.set_name('XNP','XNP_NUM_RANGE_EXISTS');
1745: fnd_message.set_token('STARTING_NUMBER',p_STARTING_NUMBER);
1746: fnd_message.set_token('ENDING_NUMBER',p_ENDING_NUMBER);
1747: app_exception.raise_exception;
1748: END IF;

Line 1745: fnd_message.set_token('STARTING_NUMBER',p_STARTING_NUMBER);

1741: IF ( (l_number_range_id is not null)
1742: AND (l_number_range_id <> nvl(p_number_range_id,-1)) )
1743: THEN
1744: fnd_message.set_name('XNP','XNP_NUM_RANGE_EXISTS');
1745: fnd_message.set_token('STARTING_NUMBER',p_STARTING_NUMBER);
1746: fnd_message.set_token('ENDING_NUMBER',p_ENDING_NUMBER);
1747: app_exception.raise_exception;
1748: END IF;
1749:

Line 1746: fnd_message.set_token('ENDING_NUMBER',p_ENDING_NUMBER);

1742: AND (l_number_range_id <> nvl(p_number_range_id,-1)) )
1743: THEN
1744: fnd_message.set_name('XNP','XNP_NUM_RANGE_EXISTS');
1745: fnd_message.set_token('STARTING_NUMBER',p_STARTING_NUMBER);
1746: fnd_message.set_token('ENDING_NUMBER',p_ENDING_NUMBER);
1747: app_exception.raise_exception;
1748: END IF;
1749:
1750: END CHECK_IF_NUM_RANGE_EXISTS;