DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on FND_MESSAGE

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

617: --
618: RETURN xmldoc;
619: EXCEPTION
620: WHEN OTHERS THEN
621: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');
622: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);
623: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);
624: FND_MSG_PUB.ADD;
625: RETURN NULL;

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

618: RETURN xmldoc;
619: EXCEPTION
620: WHEN OTHERS THEN
621: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');
622: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);
623: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);
624: FND_MSG_PUB.ADD;
625: RETURN NULL;
626: END Append_EA_Data ;

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

619: EXCEPTION
620: WHEN OTHERS THEN
621: FND_MESSAGE.SET_NAME ('CS' , 'CS_ERES_XML_GEN_FAILED');
622: FND_MESSAGE.SET_TOKEN ('SQLCODE', SQLCODE);
623: FND_MESSAGE.SET_TOKEN ('SQLERRM', SQLERRM);
624: FND_MSG_PUB.ADD;
625: RETURN NULL;
626: END Append_EA_Data ;
627:

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

2102:
2103: EXCEPTION
2104: WHEN OTHERS THEN
2105: --dbms_output.put_line('Other Error: '||sqlcode||sqlerrm);
2106: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');
2107: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);
2108: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);
2109: FND_MSG_PUB.ADD;
2110: RETURN NULL;

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

2103: EXCEPTION
2104: WHEN OTHERS THEN
2105: --dbms_output.put_line('Other Error: '||sqlcode||sqlerrm);
2106: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');
2107: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);
2108: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);
2109: FND_MSG_PUB.ADD;
2110: RETURN NULL;
2111: END Generate_XML_Document ;

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

2104: WHEN OTHERS THEN
2105: --dbms_output.put_line('Other Error: '||sqlcode||sqlerrm);
2106: FND_MESSAGE.SET_NAME('CS','CS_ERES_XML_GEN_FAILED');
2107: FND_MESSAGE.SET_TOKEN ('SQLCODE',SQLCODE);
2108: FND_MESSAGE.SET_TOKEN ('SQLERRM',SQLERRM);
2109: FND_MSG_PUB.ADD;
2110: RETURN NULL;
2111: END Generate_XML_Document ;
2112:

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

2376: -- Populate the each signer's comment to a note
2377:
2378: -- Get the approval variables populated.
2379:
2380: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2381: l_approver := FND_MESSAGE.GET;
2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');

Line 2381: l_approver := FND_MESSAGE.GET;

2377:
2378: -- Get the approval variables populated.
2379:
2380: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2381: l_approver := FND_MESSAGE.GET;
2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;

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

2378: -- Get the approval variables populated.
2379:
2380: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2381: l_approver := FND_MESSAGE.GET;
2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;
2386: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');

Line 2383: l_action := FND_MESSAGE.GET;

2379:
2380: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2381: l_approver := FND_MESSAGE.GET;
2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;
2386: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2387: l_note_title := FND_MESSAGE.GET;

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

2380: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_NAME');
2381: l_approver := FND_MESSAGE.GET;
2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;
2386: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2387: l_note_title := FND_MESSAGE.GET;
2388:

Line 2385: l_comment := FND_MESSAGE.GET;

2381: l_approver := FND_MESSAGE.GET;
2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;
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

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

2382: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_ACTION');
2383: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;
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: l_action := FND_MESSAGE.GET;
2384: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVER_COMMENT');
2385: l_comment := FND_MESSAGE.GET;
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 2480: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');

2476: END IF ; -- l_ERecord_ID
2477:
2478: IF l_spl_excp = 'Y' THEN
2479:
2480: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2481: l_note_title := FND_MESSAGE.GET;
2482:
2483: -- Get the note type and status from the profile option
2484:

Line 2481: l_note_title := FND_MESSAGE.GET;

2477:
2478: IF l_spl_excp = 'Y' THEN
2479:
2480: FND_MESSAGE.SET_NAME('CS','CS_ERES_SR_APPROVAL_RESULT');
2481: l_note_title := FND_MESSAGE.GET;
2482:
2483: -- Get the note type and status from the profile option
2484:
2485: FND_PROFILE.Get('JTF_NTS_NOTE_STATUS',l_note_status);

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

2734: -- to the previous status.
2735:
2736: -- Populate note details
2737: IF l_sig_status = 'APPROVED' THEN
2738: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2739: l_note_text := fnd_message.get;
2740: ELSIF l_sig_status = 'REJECTED' THEN
2741: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2742: l_note_text := fnd_message.get;

Line 2739: l_note_text := fnd_message.get;

2735:
2736: -- Populate note details
2737: IF l_sig_status = 'APPROVED' THEN
2738: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2739: l_note_text := fnd_message.get;
2740: ELSIF l_sig_status = 'REJECTED' THEN
2741: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2742: l_note_text := fnd_message.get;
2743: END IF ;

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

2737: IF l_sig_status = 'APPROVED' THEN
2738: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2739: l_note_text := fnd_message.get;
2740: ELSIF l_sig_status = 'REJECTED' THEN
2741: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2742: l_note_text := fnd_message.get;
2743: END IF ;
2744:
2745: -- Add a note that an error encountered while ERES processing.

Line 2742: l_note_text := fnd_message.get;

2738: fnd_message.set_name ('CS', 'CS_SR_ERES_APPROVED');
2739: l_note_text := fnd_message.get;
2740: ELSIF l_sig_status = 'REJECTED' THEN
2741: fnd_message.set_name ('CS', 'CS_SR_ERES_REJECTED');
2742: l_note_text := fnd_message.get;
2743: END IF ;
2744:
2745: -- Add a note that an error encountered while ERES processing.
2746:

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

2743: END IF ;
2744:
2745: -- Add a note that an error encountered while ERES processing.
2746:
2747: fnd_message.set_name ('CS','CS_ERES_ERROR_COMMENT_MSG');
2748: l_note_err_msg := fnd_message.get;
2749: l_note_text := l_note_text||l_chr_newline||l_note_err_msg||l_chr_newline;
2750:
2751: --Get all the error messages and add error messages to the note

Line 2748: l_note_err_msg := fnd_message.get;

2744:
2745: -- Add a note that an error encountered while ERES processing.
2746:
2747: fnd_message.set_name ('CS','CS_ERES_ERROR_COMMENT_MSG');
2748: l_note_err_msg := fnd_message.get;
2749: l_note_text := l_note_text||l_chr_newline||l_note_err_msg||l_chr_newline;
2750:
2751: --Get all the error messages and add error messages to the note
2752:

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

3072: END IF ;
3073:
3074: EXCEPTION
3075: WHEN OTHERS THEN
3076: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');
3077: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);
3078: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);
3079: FND_MSG_PUB.ADD;
3080: RAISE;

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

3073:
3074: EXCEPTION
3075: WHEN OTHERS THEN
3076: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');
3077: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);
3078: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);
3079: FND_MSG_PUB.ADD;
3080: RAISE;
3081:

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

3074: EXCEPTION
3075: WHEN OTHERS THEN
3076: FND_MESSAGE.SET_NAME('CS','CS_ERES_CALLBACK_API_FAILED');
3077: FND_MESSAGE.SET_TOKEN ('P_SQLCODE',SQLCODE);
3078: FND_MESSAGE.SET_TOKEN ('P_SQLERRM',SQLERRM);
3079: FND_MSG_PUB.ADD;
3080: RAISE;
3081:
3082: END Post_Approval_Process ;

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

3153:
3154: EXCEPTION
3155: WHEN OTHERS THEN
3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3157: FND_MESSAGE.SET_NAME('CS','CS_ERES_INVLD_INTMED_STS');
3158: FND_MSG_PUB.ADD;
3159: RAISE;
3160: END Get_Target_SR_Status ;
3161: