DBA Data[Home] [Help]

APPS.AMW_PROC_APPROVAL_PKG dependencies on FND_MESSAGE

Line 291: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');

287: exception
288:
289: when unappr_xst_excpt then
290: rollback;
291: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
292: err_msg := fnd_message.get;
293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_proc_approval_pkg',
294: p_procedure_name => 'check_hier_approved',
295: p_error_text => err_msg);

Line 292: err_msg := fnd_message.get;

288:
289: when unappr_xst_excpt then
290: rollback;
291: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
292: err_msg := fnd_message.get;
293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_proc_approval_pkg',
294: p_procedure_name => 'check_hier_approved',
295: p_error_text => err_msg);
296: raise;

Line 671: fnd_message.set_name('AMW','AMW_UNAPPRV_ASSOC');

667:
668: exception
669:
670: when unappr_obj_exception then
671: fnd_message.set_name('AMW','AMW_UNAPPRV_ASSOC');
672: err_msg := fnd_message.get;
673: if raise_ex = 'Y' then
674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_PROC_APPROVAL_PKG',
675: p_procedure_name => 'prod_err_unapr_obj_ass_ex',

Line 672: err_msg := fnd_message.get;

668: exception
669:
670: when unappr_obj_exception then
671: fnd_message.set_name('AMW','AMW_UNAPPRV_ASSOC');
672: err_msg := fnd_message.get;
673: if raise_ex = 'Y' then
674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_PROC_APPROVAL_PKG',
675: p_procedure_name => 'prod_err_unapr_obj_ass_ex',
676: p_error_text => err_msg);

Line 780: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');

776:
777: exception
778:
779: when unappr_xst_excpt then
780: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
781: err_msg := fnd_message.get;
782: p_result := 'N';
783: p_out_mesg := err_msg;
784:

Line 781: err_msg := fnd_message.get;

777: exception
778:
779: when unappr_xst_excpt then
780: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
781: err_msg := fnd_message.get;
782: p_result := 'N';
783: p_out_mesg := err_msg;
784:
785: end check_hier_approved;

Line 932: fnd_message.set_name('AMW','AMW_NS_VAR_UNAPPROVED');

928: when too_many_rows then
929: null;
930:
931: when no_data_found then
932: fnd_message.set_name('AMW','AMW_NS_VAR_UNAPPROVED');
933: p_out_mesg := fnd_message.get;
934: p_result := 'N';
935: return;
936: end;

Line 933: p_out_mesg := fnd_message.get;

929: null;
930:
931: when no_data_found then
932: fnd_message.set_name('AMW','AMW_NS_VAR_UNAPPROVED');
933: p_out_mesg := fnd_message.get;
934: p_result := 'N';
935: return;
936: end;
937: end if; -- if process is non-standard

Line 967: fnd_message.set_name('AMW','AMW_NS_VAR_UNAPPROVED');

963: when too_many_rows then
964: null;
965:
966: when no_data_found then
967: fnd_message.set_name('AMW','AMW_NS_VAR_UNAPPROVED');
968: p_out_mesg := fnd_message.get;
969: p_result := 'N';
970: return;
971: end;

Line 968: p_out_mesg := fnd_message.get;

964: null;
965:
966: when no_data_found then
967: fnd_message.set_name('AMW','AMW_NS_VAR_UNAPPROVED');
968: p_out_mesg := fnd_message.get;
969: p_result := 'N';
970: return;
971: end;
972:

Line 1030: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1026: where process_id = process_list_rec.parent_child_id
1027: and end_date is null)
1028: and END_DATE is null);
1029:
1030: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1031: p_out_mesg := fnd_message.get;
1032: p_result := 'N';
1033: return;
1034:

Line 1031: p_out_mesg := fnd_message.get;

1027: and end_date is null)
1028: and END_DATE is null);
1029:
1030: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1031: p_out_mesg := fnd_message.get;
1032: p_result := 'N';
1033: return;
1034:
1035: exception

Line 1040: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1036: when no_data_found then
1037: null;
1038:
1039: when too_many_rows then
1040: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1041: p_out_mesg := fnd_message.get;
1042: p_result := 'N';
1043: return;
1044: end;

Line 1041: p_out_mesg := fnd_message.get;

1037: null;
1038:
1039: when too_many_rows then
1040: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1041: p_out_mesg := fnd_message.get;
1042: p_result := 'N';
1043: return;
1044: end;
1045:

Line 1063: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1059: where process_id = process_list_rec.parent_child_id
1060: and up_down_ind = 'D'
1061: and hierarchy_type = 'L');
1062:
1063: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1064: p_out_mesg := fnd_message.get;
1065: p_result := 'N';
1066: return;
1067:

Line 1064: p_out_mesg := fnd_message.get;

1060: and up_down_ind = 'D'
1061: and hierarchy_type = 'L');
1062:
1063: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1064: p_out_mesg := fnd_message.get;
1065: p_result := 'N';
1066: return;
1067:
1068: exception

Line 1073: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1069: when no_data_found then
1070: null;
1071:
1072: when too_many_rows then
1073: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1074: p_out_mesg := fnd_message.get;
1075: p_result := 'N';
1076: return;
1077: end;

Line 1074: p_out_mesg := fnd_message.get;

1070: null;
1071:
1072: when too_many_rows then
1073: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1074: p_out_mesg := fnd_message.get;
1075: p_result := 'N';
1076: return;
1077: end;
1078:

Line 1108: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1104: where process_id = p_process_id
1105: and end_date is null)
1106: and END_DATE is null);
1107:
1108: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1109: p_out_mesg := fnd_message.get;
1110: p_result := 'N';
1111: return;
1112:

Line 1109: p_out_mesg := fnd_message.get;

1105: and end_date is null)
1106: and END_DATE is null);
1107:
1108: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1109: p_out_mesg := fnd_message.get;
1110: p_result := 'N';
1111: return;
1112:
1113: exception

Line 1118: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1114: when no_data_found then
1115: null;
1116:
1117: when too_many_rows then
1118: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1119: p_out_mesg := fnd_message.get;
1120: p_result := 'N';
1121: return;
1122: end;

Line 1119: p_out_mesg := fnd_message.get;

1115: null;
1116:
1117: when too_many_rows then
1118: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1119: p_out_mesg := fnd_message.get;
1120: p_result := 'N';
1121: return;
1122: end;
1123:

Line 1141: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1137: where process_id = p_process_id
1138: and up_down_ind = 'D'
1139: and hierarchy_type = 'L');
1140:
1141: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1142: p_out_mesg := fnd_message.get;
1143: p_result := 'N';
1144: return;
1145:

Line 1142: p_out_mesg := fnd_message.get;

1138: and up_down_ind = 'D'
1139: and hierarchy_type = 'L');
1140:
1141: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1142: p_out_mesg := fnd_message.get;
1143: p_result := 'N';
1144: return;
1145:
1146: exception

Line 1151: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');

1147: when no_data_found then
1148: null;
1149:
1150: when too_many_rows then
1151: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1152: p_out_mesg := fnd_message.get;
1153: p_result := 'N';
1154: return;
1155: end;

Line 1152: p_out_mesg := fnd_message.get;

1148: null;
1149:
1150: when too_many_rows then
1151: fnd_message.set_name('AMW','AMW_NS_CHILDLIST_DIFF');
1152: p_out_mesg := fnd_message.get;
1153: p_result := 'N';
1154: return;
1155: end;
1156: