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

Line 26: fnd_message.set_name('PER','PER_289658_TXN_ITEM_TYPE_MND');

22: begin
23: --
24: If p_item_type is null
25: then
26: fnd_message.set_name('PER','PER_289658_TXN_ITEM_TYPE_MND');
27: fnd_message.raise_error;
28: ElsIf p_item_key is null
29: then
30: fnd_message.set_name('PER','PER_289659_TXN_ITEM_KEY_MND');

Line 27: fnd_message.raise_error;

23: --
24: If p_item_type is null
25: then
26: fnd_message.set_name('PER','PER_289658_TXN_ITEM_TYPE_MND');
27: fnd_message.raise_error;
28: ElsIf p_item_key is null
29: then
30: fnd_message.set_name('PER','PER_289659_TXN_ITEM_KEY_MND');
31: fnd_message.raise_error;

Line 30: fnd_message.set_name('PER','PER_289659_TXN_ITEM_KEY_MND');

26: fnd_message.set_name('PER','PER_289658_TXN_ITEM_TYPE_MND');
27: fnd_message.raise_error;
28: ElsIf p_item_key is null
29: then
30: fnd_message.set_name('PER','PER_289659_TXN_ITEM_KEY_MND');
31: fnd_message.raise_error;
32: End if;
33: end chk_item_type_item_key_mand;
34: --

Line 31: fnd_message.raise_error;

27: fnd_message.raise_error;
28: ElsIf p_item_key is null
29: then
30: fnd_message.set_name('PER','PER_289659_TXN_ITEM_KEY_MND');
31: fnd_message.raise_error;
32: End if;
33: end chk_item_type_item_key_mand;
34: --
35: -- ----------------------------------------------------------------------------

Line 57: fnd_message.set_name('PER','PER_289660_TXN_INV_WFL');

53: fetch csr_item_type_exists into l_end_date;
54: If csr_item_type_exists%notfound
55: then
56: close csr_item_type_exists;
57: fnd_message.set_name('PER','PER_289660_TXN_INV_WFL');
58: fnd_message.raise_error;
59: End if;
60: close csr_item_type_exists;
61: If l_end_date is not null

Line 58: fnd_message.raise_error;

54: If csr_item_type_exists%notfound
55: then
56: close csr_item_type_exists;
57: fnd_message.set_name('PER','PER_289660_TXN_INV_WFL');
58: fnd_message.raise_error;
59: End if;
60: close csr_item_type_exists;
61: If l_end_date is not null
62: then

Line 63: fnd_message.set_name('PER','PER_289661_TXN_WFL_END');

59: End if;
60: close csr_item_type_exists;
61: If l_end_date is not null
62: then
63: fnd_message.set_name('PER','PER_289661_TXN_WFL_END');
64: fnd_message.raise_error;
65: End if;
66: exception
67: when others then

Line 64: fnd_message.raise_error;

60: close csr_item_type_exists;
61: If l_end_date is not null
62: then
63: fnd_message.set_name('PER','PER_289661_TXN_WFL_END');
64: fnd_message.raise_error;
65: End if;
66: exception
67: when others then
68: If csr_item_type_exists%isopen

Line 91: fnd_message.set_name('PER','PER_289662_TXN_INV_CREATOR');

87: --
88: begin
89: If p_creator_user_id is null
90: then
91: fnd_message.set_name('PER','PER_289662_TXN_INV_CREATOR');
92: fnd_message.raise_error;
93: End if;
94: open csr_creator_user_id;
95: fetch csr_creator_user_id into l_end_date;

Line 92: fnd_message.raise_error;

88: begin
89: If p_creator_user_id is null
90: then
91: fnd_message.set_name('PER','PER_289662_TXN_INV_CREATOR');
92: fnd_message.raise_error;
93: End if;
94: open csr_creator_user_id;
95: fetch csr_creator_user_id into l_end_date;
96: If csr_creator_user_id%notfound

Line 99: fnd_message.set_name('PER','PER_289663_TXN_INV_USER');

95: fetch csr_creator_user_id into l_end_date;
96: If csr_creator_user_id%notfound
97: then
98: close csr_creator_user_id;
99: fnd_message.set_name('PER','PER_289663_TXN_INV_USER');
100: fnd_message.raise_error;
101: End if;
102: close csr_creator_user_id;
103: If ((l_end_date is not null) and (l_end_date < sysdate))

Line 100: fnd_message.raise_error;

96: If csr_creator_user_id%notfound
97: then
98: close csr_creator_user_id;
99: fnd_message.set_name('PER','PER_289663_TXN_INV_USER');
100: fnd_message.raise_error;
101: End if;
102: close csr_creator_user_id;
103: If ((l_end_date is not null) and (l_end_date < sysdate))
104: then

Line 105: fnd_message.set_name('PER','PER_289664_TXN_USER_END');

101: End if;
102: close csr_creator_user_id;
103: If ((l_end_date is not null) and (l_end_date < sysdate))
104: then
105: fnd_message.set_name('PER','PER_289664_TXN_USER_END');
106: fnd_message.raise_error;
107: End if;
108: exception
109: when others then

Line 106: fnd_message.raise_error;

102: close csr_creator_user_id;
103: If ((l_end_date is not null) and (l_end_date < sysdate))
104: then
105: fnd_message.set_name('PER','PER_289664_TXN_USER_END');
106: fnd_message.raise_error;
107: End if;
108: exception
109: when others then
110: If csr_creator_user_id%isopen

Line 136: fnd_message.set_name('PER','PER_289665_TXN_INV_FORM');

132: fetch csr_function_id into l_function_id;
133: If csr_function_id%notfound
134: then
135: close csr_function_id;
136: fnd_message.set_name('PER','PER_289665_TXN_INV_FORM');
137: fnd_message.raise_error;
138: End if;
139: close csr_function_id;
140: Else

Line 137: fnd_message.raise_error;

133: If csr_function_id%notfound
134: then
135: close csr_function_id;
136: fnd_message.set_name('PER','PER_289665_TXN_INV_FORM');
137: fnd_message.raise_error;
138: End if;
139: close csr_function_id;
140: Else
141: fnd_message.set_name('PER','PER_289666_TXN_FORM_MND');

Line 141: fnd_message.set_name('PER','PER_289666_TXN_FORM_MND');

137: fnd_message.raise_error;
138: End if;
139: close csr_function_id;
140: Else
141: fnd_message.set_name('PER','PER_289666_TXN_FORM_MND');
142: fnd_message.raise_error;
143: End if;
144: exception
145: when others then

Line 142: fnd_message.raise_error;

138: End if;
139: close csr_function_id;
140: Else
141: fnd_message.set_name('PER','PER_289666_TXN_FORM_MND');
142: fnd_message.raise_error;
143: End if;
144: exception
145: when others then
146: If csr_function_id%isopen

Line 162: fnd_message.set_name('PER','PER_289667_TXN_MOD_CREATOR');

158: )is
159: begin
160: If p_creator_user_id <> p_current_user_id
161: then
162: fnd_message.set_name('PER','PER_289667_TXN_MOD_CREATOR');
163: fnd_message.raise_error;
164: End if;
165: end chk_transaction_creator;
166: --

Line 163: fnd_message.raise_error;

159: begin
160: If p_creator_user_id <> p_current_user_id
161: then
162: fnd_message.set_name('PER','PER_289667_TXN_MOD_CREATOR');
163: fnd_message.raise_error;
164: End if;
165: end chk_transaction_creator;
166: --
167: -- ----------------------------------------------------------------------------

Line 177: fnd_message.set_name('PER','PER_289676_TXN_INV_STATE');

173: begin
174: If p_state not in (g_start_state,g_save_for_later_state
175: ,g_pending_approval_state,g_reject_for_correction_state)
176: then
177: fnd_message.set_name('PER','PER_289676_TXN_INV_STATE');
178: fnd_message.raise_error;
179: End if;
180: end chk_state;
181: --

Line 178: fnd_message.raise_error;

174: If p_state not in (g_start_state,g_save_for_later_state
175: ,g_pending_approval_state,g_reject_for_correction_state)
176: then
177: fnd_message.set_name('PER','PER_289676_TXN_INV_STATE');
178: fnd_message.raise_error;
179: End if;
180: end chk_state;
181: --
182: -- ----------------------------------------------------------------------------

Line 191: fnd_message.set_name('PER','PER_289668_TXN_INV_SUBSTATE');

187: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE)is
188: begin
189: If (p_state <> g_save_for_later_state and p_sub_state is not null)
190: then
191: fnd_message.set_name('PER','PER_289668_TXN_INV_SUBSTATE');
192: fnd_message.raise_error;
193: Elsif (p_state = g_save_for_later_state and nvl(p_sub_state,-1)
194: not in (g_automatic_sub_state,g_manual_sub_state))
195: then

Line 192: fnd_message.raise_error;

188: begin
189: If (p_state <> g_save_for_later_state and p_sub_state is not null)
190: then
191: fnd_message.set_name('PER','PER_289668_TXN_INV_SUBSTATE');
192: fnd_message.raise_error;
193: Elsif (p_state = g_save_for_later_state and nvl(p_sub_state,-1)
194: not in (g_automatic_sub_state,g_manual_sub_state))
195: then
196: fnd_message.set_name('PER','PER_289669_TXN_SUBSTATE_VAL');

Line 196: fnd_message.set_name('PER','PER_289669_TXN_SUBSTATE_VAL');

192: fnd_message.raise_error;
193: Elsif (p_state = g_save_for_later_state and nvl(p_sub_state,-1)
194: not in (g_automatic_sub_state,g_manual_sub_state))
195: then
196: fnd_message.set_name('PER','PER_289669_TXN_SUBSTATE_VAL');
197: fnd_message.raise_error;
198: End if;
199: end chk_sub_state;
200: --

Line 197: fnd_message.raise_error;

193: Elsif (p_state = g_save_for_later_state and nvl(p_sub_state,-1)
194: not in (g_automatic_sub_state,g_manual_sub_state))
195: then
196: fnd_message.set_name('PER','PER_289669_TXN_SUBSTATE_VAL');
197: fnd_message.raise_error;
198: End if;
199: end chk_sub_state;
200: --
201: -- ----------------------------------------------------------------------------

Line 219: fnd_message.set_name('PER','PER_289681_TXN_DML_QUERY_MODE');

215: then
216: -- the current transaction is in QUERY_ONLY mode
217: If p_new_dml_mode <> g_query_only_dml_mode
218: then
219: fnd_message.set_name('PER','PER_289681_TXN_DML_QUERY_MODE');
220: fnd_message.raise_error;
221: else
222: RETURN(g_query_only_dml_mode);
223: end if;

Line 220: fnd_message.raise_error;

216: -- the current transaction is in QUERY_ONLY mode
217: If p_new_dml_mode <> g_query_only_dml_mode
218: then
219: fnd_message.set_name('PER','PER_289681_TXN_DML_QUERY_MODE');
220: fnd_message.raise_error;
221: else
222: RETURN(g_query_only_dml_mode);
223: end if;
224: end if;

Line 235: fnd_message.set_name('PER','PER_289682_TXN_DML_INV_MODE');

231: then
232: -- dml_mode was specified
233: RETURN(p_new_dml_mode);
234: else
235: fnd_message.set_name('PER','PER_289682_TXN_DML_INV_MODE');
236: fnd_message.raise_error;
237: end if;
238: end get_and_chk_and_ret_dml_mode;
239: --

Line 236: fnd_message.raise_error;

232: -- dml_mode was specified
233: RETURN(p_new_dml_mode);
234: else
235: fnd_message.set_name('PER','PER_289682_TXN_DML_INV_MODE');
236: fnd_message.raise_error;
237: end if;
238: end get_and_chk_and_ret_dml_mode;
239: --
240: -- ----------------------------------------------------------------------------

Line 308: fnd_message.set_name('PER','PER_289670_TXN_WFL_EXIST');

304: )returning transaction_id into l_tran_id;
305: return l_tran_id;
306: exception
307: when dup_val_on_index then
308: fnd_message.set_name('PER','PER_289670_TXN_WFL_EXIST');
309: fnd_message.raise_error;
310: when others then
311: raise;
312: end ins;

Line 309: fnd_message.raise_error;

305: return l_tran_id;
306: exception
307: when dup_val_on_index then
308: fnd_message.set_name('PER','PER_289670_TXN_WFL_EXIST');
309: fnd_message.raise_error;
310: when others then
311: raise;
312: end ins;
313: --

Line 472: fnd_message.set_name('PER','PER_289672_TXN_INV_STATE');

468: (p_state => g_save_for_later_state
469: ,p_sub_state => p_sub_state);
470: --
471: If p_state = g_pending_approval_state then
472: fnd_message.set_name('PER','PER_289672_TXN_INV_STATE');
473: fnd_message.raise_error;
474: End if;
475: --
476: upd(p_transaction_id => p_transaction_id

Line 473: fnd_message.raise_error;

469: ,p_sub_state => p_sub_state);
470: --
471: If p_state = g_pending_approval_state then
472: fnd_message.set_name('PER','PER_289672_TXN_INV_STATE');
473: fnd_message.raise_error;
474: End if;
475: --
476: upd(p_transaction_id => p_transaction_id
477: ,p_state => g_save_for_later_state

Line 529: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');

525: l_dml_mode,
526: l_context_display_text;
527: if csr_user_id%NOTFOUND THEN
528: close csr_user_id;
529: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
530: fnd_message.raise_error;
531: end if;
532: close csr_user_id;
533: save_for_later

Line 530: fnd_message.raise_error;

526: l_context_display_text;
527: if csr_user_id%NOTFOUND THEN
528: close csr_user_id;
529: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
530: fnd_message.raise_error;
531: end if;
532: close csr_user_id;
533: save_for_later
534: (p_transaction_id => p_transaction_id

Line 592: fnd_message.set_name('PER','PER_289671_TXN_INV');

588: l_dml_mode,
589: l_context_display_text;
590: if csr_user_id%NOTFOUND THEN
591: close csr_user_id;
592: fnd_message.set_name('PER','PER_289671_TXN_INV');
593: fnd_message.raise_error;
594: end if;
595: close csr_user_id;
596: save_for_later

Line 593: fnd_message.raise_error;

589: l_context_display_text;
590: if csr_user_id%NOTFOUND THEN
591: close csr_user_id;
592: fnd_message.set_name('PER','PER_289671_TXN_INV');
593: fnd_message.raise_error;
594: end if;
595: close csr_user_id;
596: save_for_later
597: (p_transaction_id => p_transaction_id

Line 643: fnd_message.set_name('PER','PER_289671_TXN_INV');

639: open csr_vo_cache;
640: fetch csr_vo_cache into l_db_clob;
641: if csr_vo_cache%NOTFOUND THEN
642: close csr_vo_cache;
643: fnd_message.set_name('PER','PER_289671_TXN_INV');
644: fnd_message.raise_error;
645: end if;
646: close csr_vo_cache;
647:

Line 644: fnd_message.raise_error;

640: fetch csr_vo_cache into l_db_clob;
641: if csr_vo_cache%NOTFOUND THEN
642: close csr_vo_cache;
643: fnd_message.set_name('PER','PER_289671_TXN_INV');
644: fnd_message.raise_error;
645: end if;
646: close csr_vo_cache;
647:
648: DBMS_LOB.WRITE(l_db_clob,

Line 686: fnd_message.set_name('PER','PER_289673_TXN_QUERY');

682: ,p_sub_state => p_sub_state);
683: --
684: If p_dml_mode = g_query_only_dml_mode
685: then
686: fnd_message.set_name('PER','PER_289673_TXN_QUERY');
687: fnd_message.raise_error;
688: End if;
689: --
690: If p_state = g_pending_approval_state

Line 687: fnd_message.raise_error;

683: --
684: If p_dml_mode = g_query_only_dml_mode
685: then
686: fnd_message.set_name('PER','PER_289673_TXN_QUERY');
687: fnd_message.raise_error;
688: End if;
689: --
690: If p_state = g_pending_approval_state
691: then

Line 692: fnd_message.set_name('PER','PER_289674_TXN_PENDING');

688: End if;
689: --
690: If p_state = g_pending_approval_state
691: then
692: fnd_message.set_name('PER','PER_289674_TXN_PENDING');
693: fnd_message.raise_error;
694: End if;
695: upd(p_transaction_id => p_transaction_id
696: ,p_state => g_pending_approval_state

Line 693: fnd_message.raise_error;

689: --
690: If p_state = g_pending_approval_state
691: then
692: fnd_message.set_name('PER','PER_289674_TXN_PENDING');
693: fnd_message.raise_error;
694: End if;
695: upd(p_transaction_id => p_transaction_id
696: ,p_state => g_pending_approval_state
697: ,p_sub_state => null

Line 747: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');

743: l_dml_mode,
744: l_context_display_text;
745: if csr_user_id%NOTFOUND THEN
746: close csr_user_id;
747: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
748: fnd_message.raise_error;
749: end if;
750: close csr_user_id;
751: pending_approval

Line 748: fnd_message.raise_error;

744: l_context_display_text;
745: if csr_user_id%NOTFOUND THEN
746: close csr_user_id;
747: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
748: fnd_message.raise_error;
749: end if;
750: close csr_user_id;
751: pending_approval
752: (p_transaction_id => l_transaction_id

Line 808: fnd_message.set_name('PER','PER_289671_TXN_INV');

804: l_dml_mode,
805: l_context_display_text;
806: if csr_user_id%NOTFOUND THEN
807: close csr_user_id;
808: fnd_message.set_name('PER','PER_289671_TXN_INV');
809: fnd_message.raise_error;
810: end if;
811: close csr_user_id;
812: pending_approval

Line 809: fnd_message.raise_error;

805: l_context_display_text;
806: if csr_user_id%NOTFOUND THEN
807: close csr_user_id;
808: fnd_message.set_name('PER','PER_289671_TXN_INV');
809: fnd_message.raise_error;
810: end if;
811: close csr_user_id;
812: pending_approval
813: (p_transaction_id => p_transaction_id

Line 853: fnd_message.set_name('PER','PER_289675_TXN_PEN_REJ_CORR');

849: l_amount number;
850: begin
851: If p_state <> g_pending_approval_state
852: then
853: fnd_message.set_name('PER','PER_289675_TXN_PEN_REJ_CORR');
854: fnd_message.raise_error;
855: End if;
856: --
857: -- Convert clob to varchar2 datatype for comparision

Line 854: fnd_message.raise_error;

850: begin
851: If p_state <> g_pending_approval_state
852: then
853: fnd_message.set_name('PER','PER_289675_TXN_PEN_REJ_CORR');
854: fnd_message.raise_error;
855: End if;
856: --
857: -- Convert clob to varchar2 datatype for comparision
858: --

Line 909: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');

905: l_dml_mode,
906: l_context_display_text;
907: if csr_user_id%NOTFOUND THEN
908: close csr_user_id;
909: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
910: fnd_message.raise_error;
911: end if;
912: close csr_user_id;
913: reject_for_correction(p_transaction_id => l_transaction_id

Line 910: fnd_message.raise_error;

906: l_context_display_text;
907: if csr_user_id%NOTFOUND THEN
908: close csr_user_id;
909: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
910: fnd_message.raise_error;
911: end if;
912: close csr_user_id;
913: reject_for_correction(p_transaction_id => l_transaction_id
914: ,p_state => l_state

Line 955: fnd_message.set_name('PER','PER_289671_TXN_INV');

951: l_dml_mode,
952: l_context_display_text;
953: if csr_user_id%NOTFOUND THEN
954: close csr_user_id;
955: fnd_message.set_name('PER','PER_289671_TXN_INV');
956: fnd_message.raise_error;
957: end if;
958: close csr_user_id;
959: reject_for_correction(p_transaction_id => p_transaction_id

Line 956: fnd_message.raise_error;

952: l_context_display_text;
953: if csr_user_id%NOTFOUND THEN
954: close csr_user_id;
955: fnd_message.set_name('PER','PER_289671_TXN_INV');
956: fnd_message.raise_error;
957: end if;
958: close csr_user_id;
959: reject_for_correction(p_transaction_id => p_transaction_id
960: ,p_state => l_state

Line 1002: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');

998: fetch csr_transaction into l_transaction_id;
999: If csr_transaction%notfound
1000: then
1001: close csr_transaction;
1002: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
1003: fnd_message.raise_error;
1004: End if;
1005: close csr_transaction;
1006: --

Line 1003: fnd_message.raise_error;

999: If csr_transaction%notfound
1000: then
1001: close csr_transaction;
1002: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
1003: fnd_message.raise_error;
1004: End if;
1005: close csr_transaction;
1006: --
1007: delete from hr_wip_locks

Line 1042: fnd_message.set_name('PER','PER_289671_TXN_INV');

1038: fetch csr_transaction into l_transaction_id;
1039: If csr_transaction%notfound
1040: then
1041: close csr_transaction;
1042: fnd_message.set_name('PER','PER_289671_TXN_INV');
1043: fnd_message.raise_error;
1044: End if;
1045: close csr_transaction;
1046: delete from hr_wip_locks

Line 1043: fnd_message.raise_error;

1039: If csr_transaction%notfound
1040: then
1041: close csr_transaction;
1042: fnd_message.set_name('PER','PER_289671_TXN_INV');
1043: fnd_message.raise_error;
1044: End if;
1045: close csr_transaction;
1046: delete from hr_wip_locks
1047: where transaction_id = p_transaction_id;

Line 1103: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');

1099: l_context_display_text;
1100: If csr_transaction%notfound
1101: then
1102: close csr_transaction;
1103: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
1104: fnd_message.raise_error;
1105: End if;
1106: close csr_transaction;
1107: chk_state(p_state => p_state);

Line 1104: fnd_message.raise_error;

1100: If csr_transaction%notfound
1101: then
1102: close csr_transaction;
1103: fnd_message.set_name('PER','PER_289680_TXN_INV_WFL');
1104: fnd_message.raise_error;
1105: End if;
1106: close csr_transaction;
1107: chk_state(p_state => p_state);
1108: chk_sub_state(p_state => p_state

Line 1168: fnd_message.set_name('PER','PER_289671_TXN_INV');

1164: l_context_display_text;
1165: If csr_transaction%notfound
1166: then
1167: close csr_transaction;
1168: fnd_message.set_name('PER','PER_289671_TXN_INV');
1169: fnd_message.raise_error;
1170: End if;
1171: close csr_transaction;
1172: upd(p_transaction_id => p_transaction_id

Line 1169: fnd_message.raise_error;

1165: If csr_transaction%notfound
1166: then
1167: close csr_transaction;
1168: fnd_message.set_name('PER','PER_289671_TXN_INV');
1169: fnd_message.raise_error;
1170: End if;
1171: close csr_transaction;
1172: upd(p_transaction_id => p_transaction_id
1173: ,p_state => p_state