DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on FND_MESSAGE

Line 605: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');

601: --
602: RETURN xmldoc;
603: EXCEPTION
604: WHEN OTHERS THEN
605: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);
607: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);
608: FND_MSG_PUB.ADD;
609: RETURN NULL;

Line 606: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);

602: RETURN xmldoc;
603: EXCEPTION
604: WHEN OTHERS THEN
605: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);
607: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);
608: FND_MSG_PUB.ADD;
609: RETURN NULL;
610: END Append_EA_Data ;

Line 607: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);

603: EXCEPTION
604: WHEN OTHERS THEN
605: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');
606: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);
607: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);
608: FND_MSG_PUB.ADD;
609: RETURN NULL;
610: END Append_EA_Data ;
611:

Line 2021: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');

2017:
2018: EXCEPTION
2019: WHEN OTHERS THEN
2020: --dbms_output.put_line('Other Error: '||sqlcode||sqlerrm);
2021: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');
2022: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);
2023: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: RETURN NULL;

Line 2022: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);

2018: EXCEPTION
2019: WHEN OTHERS THEN
2020: --dbms_output.put_line('Other Error: '||sqlcode||sqlerrm);
2021: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');
2022: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);
2023: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: RETURN NULL;
2026: END Generate_XML_Document ;

Line 2023: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);

2019: WHEN OTHERS THEN
2020: --dbms_output.put_line('Other Error: '||sqlcode||sqlerrm);
2021: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');
2022: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);
2023: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);
2024: FND_MSG_PUB.ADD;
2025: RETURN NULL;
2026: END Generate_XML_Document ;
2027:

Line 2291: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');

2287: -- Populate the each signer's comment to a note
2288:
2289: -- Get the approval variables populated.
2290:
2291: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2292: l_approver := FND_MESSAGE.GET;
2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');

Line 2292: l_approver := FND_MESSAGE.GET;

2288:
2289: -- Get the approval variables populated.
2290:
2291: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2292: l_approver := FND_MESSAGE.GET;
2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;

Line 2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');

2289: -- Get the approval variables populated.
2290:
2291: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2292: l_approver := FND_MESSAGE.GET;
2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;
2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');

Line 2294: l_action := FND_MESSAGE.GET;

2290:
2291: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2292: l_approver := FND_MESSAGE.GET;
2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;
2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2298: l_note_title := FND_MESSAGE.GET;

Line 2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');

2291: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2292: l_approver := FND_MESSAGE.GET;
2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;
2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2298: l_note_title := FND_MESSAGE.GET;
2299:

Line 2296: l_comment := FND_MESSAGE.GET;

2292: l_approver := FND_MESSAGE.GET;
2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;
2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2298: l_note_title := FND_MESSAGE.GET;
2299:
2300: -- Get the note type and status from the profile option

Line 2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');

2293: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;
2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2298: l_note_title := FND_MESSAGE.GET;
2299:
2300: -- Get the note type and status from the profile option
2301:

Line 2298: l_note_title := FND_MESSAGE.GET;

2294: l_action := FND_MESSAGE.GET;
2295: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2296: l_comment := FND_MESSAGE.GET;
2297: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2298: l_note_title := FND_MESSAGE.GET;
2299:
2300: -- Get the note type and status from the profile option
2301:
2302: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);

Line 2386: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');

2382: END IF ; -- l_ERecord_ID
2383:
2384: IF l_spl_excp = 'Y' THEN
2385:
2386: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2387: l_note_title := FND_MESSAGE.GET;
2388:
2389: -- Get the note type and status from the profile option
2390:

Line 2387: l_note_title := FND_MESSAGE.GET;

2383:
2384: IF l_spl_excp = 'Y' THEN
2385:
2386: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2387: l_note_title := FND_MESSAGE.GET;
2388:
2389: -- Get the note type and status from the profile option
2390:
2391: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);

Line 2644: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');

2640: -- to the previous status.
2641:
2642: -- Populate note details
2643: IF l_sig_status = 'APPROVED' THEN
2644: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2645: l_note_text := fnd_message.get;
2646: ELSIF l_sig_status = 'REJECTED' THEN
2647: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2648: l_note_text := fnd_message.get;

Line 2645: l_note_text := fnd_message.get;

2641:
2642: -- Populate note details
2643: IF l_sig_status = 'APPROVED' THEN
2644: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2645: l_note_text := fnd_message.get;
2646: ELSIF l_sig_status = 'REJECTED' THEN
2647: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2648: l_note_text := fnd_message.get;
2649: END IF ;

Line 2647: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');

2643: IF l_sig_status = 'APPROVED' THEN
2644: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2645: l_note_text := fnd_message.get;
2646: ELSIF l_sig_status = 'REJECTED' THEN
2647: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2648: l_note_text := fnd_message.get;
2649: END IF ;
2650:
2651: -- Add a note that an error encountered while ERES processing.

Line 2648: l_note_text := fnd_message.get;

2644: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2645: l_note_text := fnd_message.get;
2646: ELSIF l_sig_status = 'REJECTED' THEN
2647: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2648: l_note_text := fnd_message.get;
2649: END IF ;
2650:
2651: -- Add a note that an error encountered while ERES processing.
2652:

Line 2653: fnd_message.set_name ('CS','CS_ERES_ERROR_COMMENT_MSG');

2649: END IF ;
2650:
2651: -- Add a note that an error encountered while ERES processing.
2652:
2653: fnd_message.set_name ('CS','CS_ERES_ERROR_COMMENT_MSG');
2654: l_note_err_msg := fnd_message.get;
2655: l_note_text := l_note_text||l_chr_newline||l_note_err_msg||l_chr_newline;
2656:
2657: --Get all the error messages and add error messages to the note

Line 2654: l_note_err_msg := fnd_message.get;

2650:
2651: -- Add a note that an error encountered while ERES processing.
2652:
2653: fnd_message.set_name ('CS','CS_ERES_ERROR_COMMENT_MSG');
2654: l_note_err_msg := fnd_message.get;
2655: l_note_text := l_note_text||l_chr_newline||l_note_err_msg||l_chr_newline;
2656:
2657: --Get all the error messages and add error messages to the note
2658:

Line 2982: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');

2978: END IF ;
2979:
2980: EXCEPTION
2981: WHEN OTHERS THEN
2982: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');
2983: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);
2984: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);
2985: FND_MSG_PUB.ADD;
2986: RAISE;

Line 2983: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);

2979:
2980: EXCEPTION
2981: WHEN OTHERS THEN
2982: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');
2983: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);
2984: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);
2985: FND_MSG_PUB.ADD;
2986: RAISE;
2987:

Line 2984: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);

2980: EXCEPTION
2981: WHEN OTHERS THEN
2982: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');
2983: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);
2984: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);
2985: FND_MSG_PUB.ADD;
2986: RAISE;
2987:
2988: END Post_Approval_Process ;

Line 3063: FND_MESSAGE.SET_NAME('CS','CS_ERES_INVLD_INTMED_STS');

3059:
3060: EXCEPTION
3061: WHEN OTHERS THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3063: FND_MESSAGE.SET_NAME('CS','CS_ERES_INVLD_INTMED_STS');
3064: FND_MSG_PUB.ADD;
3065: RAISE;
3066: END Get_Target_SR_Status ;
3067: