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;
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 ;
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:
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;
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 ;
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:
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');
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;
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');
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;
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:
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
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:
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);
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:
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);
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;
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 ;
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.
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:
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
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:
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;
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:
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 ;
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: