DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on FND_MESSAGE

Line 259: /* using FND_MESSAGE. The calling routine will retrieve the message from */

255: /* */
256: /* This routine returns TRUE if successful; otherwise, it returns FALSE */
257: /* */
258: /* In case of failure, this routine will populate the global Message Stack */
259: /* using FND_MESSAGE. The calling routine will retrieve the message from */
260: /* the Stack */
261: /* */
262: /* When invoked from a Concurrent Process, the calling process has to */
263: /* initialize values for User ID, User Responsibility ID, Calling */

Line 272: /* FND_MESSAGE */

268: /* */
269: /* FND_GLOBAL */
270: /* FND_PROFILE */
271: /* FND_INSTALLATION */
272: /* FND_MESSAGE */
273: /* FND_FLEX_EXT */
274: /* FND_FLEX_APIS */
275: /* */
276: /* GL Tables which are being used include : */

Line 2386: message_token('EVENT', FND_MESSAGE.GET_ENCODED);

2382: dbms_sql.close_cursor(cur_ussgl);
2383: end if;
2384:
2385: message_token('PROCEDURE', 'Funds Checker');
2386: message_token('EVENT', FND_MESSAGE.GET_ENCODED);
2387: add_message('SQLGL', 'GL_UNHANDLED_EXCEPTION');
2388:
2389: -- =========================== FND LOG ===========================
2390: psa_utils.debug_other_string(g_state_level,l_full_path, ' RETURN -> FALSE ');

Line 6697: FND_MESSAGE.SET_NAME(appname, msgname);

6693:
6694: if ((appname is not null) and
6695: (msgname is not null)) then
6696:
6697: FND_MESSAGE.SET_NAME(appname, msgname);
6698:
6699: if g_no_msg_tokens is not null then
6700:
6701: for i in 1..g_no_msg_tokens loop

Line 6702: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));

6698:
6699: if g_no_msg_tokens is not null then
6700:
6701: for i in 1..g_no_msg_tokens loop
6702: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
6703: end loop;
6704:
6705: end if;
6706:

Line 7984: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0031');

7980: l_check_flag := p_check_flag;
7981: l_ledger_id := p_ledger_id;
7982:
7983: --Get the Application Name
7984: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0031');
7985: l_application_name := FND_MESSAGE.GET();
7986:
7987: --Get the Report Name
7988: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0030');

Line 7985: l_application_name := FND_MESSAGE.GET();

7981: l_ledger_id := p_ledger_id;
7982:
7983: --Get the Application Name
7984: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0031');
7985: l_application_name := FND_MESSAGE.GET();
7986:
7987: --Get the Report Name
7988: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0030');
7989: l_report_name := FND_MESSAGE.GET();

Line 7988: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0030');

7984: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0031');
7985: l_application_name := FND_MESSAGE.GET();
7986:
7987: --Get the Report Name
7988: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0030');
7989: l_report_name := FND_MESSAGE.GET();
7990:
7991: --Get the Funds Action
7992: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN

Line 7989: l_report_name := FND_MESSAGE.GET();

7985: l_application_name := FND_MESSAGE.GET();
7986:
7987: --Get the Report Name
7988: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0030');
7989: l_report_name := FND_MESSAGE.GET();
7990:
7991: --Get the Funds Action
7992: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN
7993: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');

Line 7993: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');

7989: l_report_name := FND_MESSAGE.GET();
7990:
7991: --Get the Funds Action
7992: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN
7993: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');
7994: ELSIF (l_check_flag = 'R' OR l_check_flag = 'P') THEN
7995: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0033');
7996: ELSE
7997: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');

Line 7995: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0033');

7991: --Get the Funds Action
7992: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN
7993: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');
7994: ELSIF (l_check_flag = 'R' OR l_check_flag = 'P') THEN
7995: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0033');
7996: ELSE
7997: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');
7998: END IF;
7999: l_funds_action := FND_MESSAGE.GET();

Line 7997: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');

7993: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');
7994: ELSIF (l_check_flag = 'R' OR l_check_flag = 'P') THEN
7995: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0033');
7996: ELSE
7997: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');
7998: END IF;
7999: l_funds_action := FND_MESSAGE.GET();
8000:
8001: --Get the Failure/Warning message

Line 7999: l_funds_action := FND_MESSAGE.GET();

7995: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0033');
7996: ELSE
7997: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0032');
7998: END IF;
7999: l_funds_action := FND_MESSAGE.GET();
8000:
8001: --Get the Failure/Warning message
8002: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN
8003: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');

Line 8003: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');

7999: l_funds_action := FND_MESSAGE.GET();
8000:
8001: --Get the Failure/Warning message
8002: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN
8003: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');
8004: ELSIF (l_check_flag = 'R' OR l_check_flag = 'P') THEN
8005: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0036');
8006: ELSE
8007: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');

Line 8005: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0036');

8001: --Get the Failure/Warning message
8002: IF (l_check_flag = 'C' OR l_check_flag = 'M') THEN
8003: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');
8004: ELSIF (l_check_flag = 'R' OR l_check_flag = 'P') THEN
8005: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0036');
8006: ELSE
8007: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');
8008: END IF;
8009: l_failure_warning := FND_MESSAGE.GET();

Line 8007: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');

8003: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');
8004: ELSIF (l_check_flag = 'R' OR l_check_flag = 'P') THEN
8005: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0036');
8006: ELSE
8007: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');
8008: END IF;
8009: l_failure_warning := FND_MESSAGE.GET();
8010:
8011: --Picking the date from the database

Line 8009: l_failure_warning := FND_MESSAGE.GET();

8005: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0036');
8006: ELSE
8007: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0035');
8008: END IF;
8009: l_failure_warning := FND_MESSAGE.GET();
8010:
8011: --Picking the date from the database
8012: SELECT
8013: TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI')

Line 8083: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0037');

8079: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_check_flag -> '||l_check_flag);
8080: -- =========================== FND LOG =============================
8081:
8082: IF (l_budgetary_control_flag = 'N') THEN
8083: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0037');
8084: l_bc_not_enabled_msg := FND_MESSAGE.GET();
8085: -- =========================== FND LOG ===========================
8086: psa_utils.debug_other_string(g_state_level, l_full_path,
8087: 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag); --Need to finalize the debug level

Line 8084: l_bc_not_enabled_msg := FND_MESSAGE.GET();

8080: -- =========================== FND LOG =============================
8081:
8082: IF (l_budgetary_control_flag = 'N') THEN
8083: FND_MESSAGE.SET_NAME('PSA', 'R_FCMA0037');
8084: l_bc_not_enabled_msg := FND_MESSAGE.GET();
8085: -- =========================== FND LOG ===========================
8086: psa_utils.debug_other_string(g_state_level, l_full_path,
8087: 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag); --Need to finalize the debug level
8088: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_bc_not_enabled_msg);

Line 9697: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');

9693: ' Related Entity Code: '||bflow_rec.bflow_entity_code||
9694: ' Related Source identifier Num 1: '||bflow_rec.bflow_source_id_num_1||
9695: ' Related Distribution Type: '||bflow_rec.bflow_distribution_type||
9696: ' Related Distribution Identifier Num 1: '||bflow_rec.bflow_dist_id_num_1;
9697: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9698: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9699: -- Fnd_Msg_Pub.ADD;
9700: psa_bc_xla_pvt.psa_xla_error
9701: (

Line 9698: Fnd_Message.Set_Token('PARAM_NAME',l_message);

9694: ' Related Source identifier Num 1: '||bflow_rec.bflow_source_id_num_1||
9695: ' Related Distribution Type: '||bflow_rec.bflow_distribution_type||
9696: ' Related Distribution Identifier Num 1: '||bflow_rec.bflow_dist_id_num_1;
9697: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9698: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9699: -- Fnd_Msg_Pub.ADD;
9700: psa_bc_xla_pvt.psa_xla_error
9701: (
9702: p_message_code => 'PSA_BC_XLA_ERROR',

Line 9715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');

9711: WHERE NOT EXISTS (SELECT 1
9712: FROM xla_ae_lines_gt l
9713: WHERE l.event_id = e.event_id)) LOOP
9714: l_message := 'Event '||events_rec.event_id||' is not processed.';
9715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9716: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9717: psa_bc_xla_pvt.psa_xla_error
9718: (
9719: p_message_code => 'PSA_BC_XLA_ERROR',

Line 9716: Fnd_Message.Set_Token('PARAM_NAME',l_message);

9712: FROM xla_ae_lines_gt l
9713: WHERE l.event_id = e.event_id)) LOOP
9714: l_message := 'Event '||events_rec.event_id||' is not processed.';
9715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9716: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9717: psa_bc_xla_pvt.psa_xla_error
9718: (
9719: p_message_code => 'PSA_BC_XLA_ERROR',
9720: p_event_id => events_rec.event_id

Line 9732: Fnd_message.set_name('PSA','PSA_GL_BC_PACKETS_EMPTY');

9728: WHERE NOT EXISTS (SELECT 1
9729: FROM xla_psa_bc_lines_v l
9730: WHERE l.event_id = e.event_id)) LOOP
9731: l_message := 'Event '||events_rec.event_id||' is not processed.';
9732: Fnd_message.set_name('PSA','PSA_GL_BC_PACKETS_EMPTY');
9733: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9734: psa_bc_xla_pvt.psa_xla_error
9735: (
9736: p_message_code => 'PSA_GL_BC_PACKETS_EMPTY',

Line 9733: Fnd_Message.Set_Token('PARAM_NAME',l_message);

9729: FROM xla_psa_bc_lines_v l
9730: WHERE l.event_id = e.event_id)) LOOP
9731: l_message := 'Event '||events_rec.event_id||' is not processed.';
9732: Fnd_message.set_name('PSA','PSA_GL_BC_PACKETS_EMPTY');
9733: Fnd_Message.Set_Token('PARAM_NAME',l_message);
9734: psa_bc_xla_pvt.psa_xla_error
9735: (
9736: p_message_code => 'PSA_GL_BC_PACKETS_EMPTY',
9737: p_event_id => events_rec.event_id