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

Line 87: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_ORG_ASSIGNMENT');

83: IF( l_assignment_count = 0) then
84: Set_Return_Status(x_orig_status => x_return_status,
85: p_new_status => FND_API.G_RET_STS_ERROR);
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_ORG_ASSIGNMENT');
88: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
89: FND_MSG_PUB.Add;
90: END IF;
91: END IF;

Line 88: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

84: Set_Return_Status(x_orig_status => x_return_status,
85: p_new_status => FND_API.G_RET_STS_ERROR);
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_ORG_ASSIGNMENT');
88: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
89: FND_MSG_PUB.Add;
90: END IF;
91: END IF;
92:

Line 99: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_ORG_ASSIGNMENT');

95:
96: Set_Return_Status(x_orig_status => x_return_status,
97: p_new_status => FND_API.G_RET_STS_ERROR);
98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
99: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_ORG_ASSIGNMENT');
100: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
101: FND_MSG_PUB.Add;
102: END IF;
103:

Line 100: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

96: Set_Return_Status(x_orig_status => x_return_status,
97: p_new_status => FND_API.G_RET_STS_ERROR);
98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
99: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_ORG_ASSIGNMENT');
100: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
101: FND_MSG_PUB.Add;
102: END IF;
103:
104: END;

Line 186: FND_MESSAGE.SET_NAME('FUN', 'FUN_DUPL_TRX_NUM');

182: IF p_trx_tbl(J).batch_id=p_batch_id AND p_trx_tbl(J).trx_number = p_trx_tbl(I).trx_number THEN
183: l_count := l_count+1;
184: END IF;
185: IF l_count > 1 THEN
186: FND_MESSAGE.SET_NAME('FUN', 'FUN_DUPL_TRX_NUM');
187: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(J).trx_number);
188: FND_MSG_PUB.Add;
189: Set_Return_Status(x_orig_status => x_return_status,
190: p_new_status => FND_API.G_RET_STS_ERROR);

Line 187: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(J).trx_number);

183: l_count := l_count+1;
184: END IF;
185: IF l_count > 1 THEN
186: FND_MESSAGE.SET_NAME('FUN', 'FUN_DUPL_TRX_NUM');
187: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(J).trx_number);
188: FND_MSG_PUB.Add;
189: Set_Return_Status(x_orig_status => x_return_status,
190: p_new_status => FND_API.G_RET_STS_ERROR);
191: EXIT;

Line 221: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_DUPLICATE_BATCH_NUM');

217: FETCH batch_num_csr INTO l_count;
218: CLOSE batch_num_csr;
219: IF l_count > 0 OR p_batch_number IS NULL THEN
220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
221: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_DUPLICATE_BATCH_NUM');
222: FND_MSG_PUB.Add;
223: END IF;
224: Set_Return_Status(x_orig_status => x_return_status,
225: p_new_status => FND_API.G_RET_STS_ERROR);

Line 343: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');

339: FUN_TCA_PKG.get_ic_org_valid_dates(p_party_id,l_le_start_dt, l_le_end_dt);
340: IF p_type = 'I' THEN
341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
343: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
344: ELSE
345: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR_DATE');
346: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
347: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));

Line 345: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR_DATE');

341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
343: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
344: ELSE
345: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR_DATE');
346: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
347: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
348: END IF;
349: FND_MSG_PUB.Add;

Line 346: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));

342: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
343: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
344: ELSE
345: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR_DATE');
346: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
347: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
348: END IF;
349: FND_MSG_PUB.Add;
350: END IF;

Line 347: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));

343: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
344: ELSE
345: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR_DATE');
346: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
347: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
348: END IF;
349: FND_MSG_PUB.Add;
350: END IF;
351: ELSE

Line 354: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');

350: END IF;
351: ELSE
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
353: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
354: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
355: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
356: ELSE
357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');
358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

Line 355: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

351: ELSE
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
353: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
354: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
355: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
356: ELSE
357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');
358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
359: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));

Line 357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');

353: IF l_le_start_dt IS NULL AND l_le_end_dt IS NULL THEN
354: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
355: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
356: ELSE
357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');
358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
359: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
360: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
361: END IF;

Line 358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

354: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
355: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
356: ELSE
357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');
358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
359: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
360: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
361: END IF;
362: FND_MSG_PUB.Add;

Line 359: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));

355: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
356: ELSE
357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');
358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
359: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
360: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
361: END IF;
362: FND_MSG_PUB.Add;
363: END IF;

Line 360: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));

356: ELSE
357: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT_DATE');
358: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
359: FND_MESSAGE.SET_TOKEN('P_START_DATE',to_char(l_le_start_dt));
360: FND_MESSAGE.SET_TOKEN('P_END_DATE',to_char(l_le_end_dt));
361: END IF;
362: FND_MSG_PUB.Add;
363: END IF;
364: END IF;

Line 378: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');

374:
375: IF legal_entity_csr%NOTFOUND THEN
376: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
377: IF p_type = 'I' THEN
378: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
379: FND_MSG_PUB.Add;
380: ELSE
381: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
382: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

Line 381: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');

377: IF p_type = 'I' THEN
378: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
379: FND_MSG_PUB.Add;
380: ELSE
381: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
382: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
383: FND_MSG_PUB.Add;
384: END IF;
385: END IF;

Line 382: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

378: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_INITIATOR');
379: FND_MSG_PUB.Add;
380: ELSE
381: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_RECIPIENT');
382: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
383: FND_MSG_PUB.Add;
384: END IF;
385: END IF;
386: Set_Return_Status(x_orig_status => x_return_status,

Line 397: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_INIT_LE');

393: IF NOT ( p_batch_date BETWEEN Nvl(l_le_start_dt, p_batch_date) AND Nvl(l_le_end_dt, p_batch_date))
394: THEN
395: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
396: IF p_type = 'I' THEN
397: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_INIT_LE');
398: FND_MSG_PUB.Add;
399: ELSE
400: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_RECI_LE');
401: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_trx_number);

Line 400: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_RECI_LE');

396: IF p_type = 'I' THEN
397: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_INIT_LE');
398: FND_MSG_PUB.Add;
399: ELSE
400: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_RECI_LE');
401: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_trx_number);
402: FND_MSG_PUB.Add;
403: END IF;
404: END IF;

Line 401: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_trx_number);

397: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_INIT_LE');
398: FND_MSG_PUB.Add;
399: ELSE
400: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INACTIVE_RECI_LE');
401: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_trx_number);
402: FND_MSG_PUB.Add;
403: END IF;
404: END IF;
405: Set_Return_Status(x_orig_status => x_return_status,

Line 414: FND_MESSAGE.SET_NAME('FUN', 'FUN_PARTY_NO_MSR');

410: IF p_local = 'N' THEN
411: l_msr := Fun_Tca_Pkg.Get_System_Reference(p_party_id);
412: IF l_msr IS NULL THEN
413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.SET_NAME('FUN', 'FUN_PARTY_NO_MSR');
415: FND_MSG_PUB.Add;
416: END IF;
417: Set_Return_Status(x_orig_status => x_return_status,
418: p_new_status => FND_API.G_RET_STS_ERROR);

Line 424: FND_MESSAGE.SET_NAME('FUN', 'ERROR_IN_IS_PARTY_VALID');

420: END IF;
421:
422: Debug('IS_PARTY_VALID(-)');
423: EXCEPTION WHEN OTHERS THEN -- Problem here: Remove check
424: FND_MESSAGE.SET_NAME('FUN', 'ERROR_IN_IS_PARTY_VALID');
425: FND_MSG_PUB.ADD;
426:
427: END;
428:

Line 494: FND_MESSAGE.SET_NAME('FUN', 'FUN_IC_INI_HDR_DIST_MISMATCH');

490: IF (p_trx_amount_cr <> l_dist_total_dr OR
491: p_trx_amount_dr <> l_dist_total_cr )
492: THEN
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
494: FND_MESSAGE.SET_NAME('FUN', 'FUN_IC_INI_HDR_DIST_MISMATCH');
495: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
496: FND_MSG_PUB.Add;
497: END IF;
498: Set_Return_Status(x_orig_status => x_return_status,

Line 495: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

491: p_trx_amount_dr <> l_dist_total_cr )
492: THEN
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
494: FND_MESSAGE.SET_NAME('FUN', 'FUN_IC_INI_HDR_DIST_MISMATCH');
495: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
496: FND_MSG_PUB.Add;
497: END IF;
498: Set_Return_Status(x_orig_status => x_return_status,
499: p_new_status => FND_API.G_RET_STS_ERROR);

Line 506: FND_MESSAGE.SET_NAME('FUN', 'FUN_IC_INVALID_DRCR_DIST');

502: IF l_dist_cr_type = l_dist_dr_type
503: THEN
504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN
506: FND_MESSAGE.SET_NAME('FUN', 'FUN_IC_INVALID_DRCR_DIST');
507: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
508: FND_MSG_PUB.Add;
509: END IF;
510: Set_Return_Status(x_orig_status => x_return_status,

Line 507: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

503: THEN
504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN
506: FND_MESSAGE.SET_NAME('FUN', 'FUN_IC_INVALID_DRCR_DIST');
507: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
508: FND_MSG_PUB.Add;
509: END IF;
510: Set_Return_Status(x_orig_status => x_return_status,
511: p_new_status => FND_API.G_RET_STS_ERROR);

Line 573: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_LINE_AMT_LESSTN_MIN');

569: l_conv_type,
570: l_min_amt)
571: THEN
572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
573: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_LINE_AMT_LESSTN_MIN');
574: FND_MESSAGE.SET_TOKEN('MIN_TRX_AMT', l_min_curr_code||' '||l_min_amt);
575: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
576: FND_MSG_PUB.Add;
577: END IF;

Line 574: FND_MESSAGE.SET_TOKEN('MIN_TRX_AMT', l_min_curr_code||' '||l_min_amt);

570: l_min_amt)
571: THEN
572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
573: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_LINE_AMT_LESSTN_MIN');
574: FND_MESSAGE.SET_TOKEN('MIN_TRX_AMT', l_min_curr_code||' '||l_min_amt);
575: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
576: FND_MSG_PUB.Add;
577: END IF;
578: Set_Return_Status(x_orig_status => x_return_status,

Line 575: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);

571: THEN
572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
573: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_LINE_AMT_LESSTN_MIN');
574: FND_MESSAGE.SET_TOKEN('MIN_TRX_AMT', l_min_curr_code||' '||l_min_amt);
575: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_number);
576: FND_MSG_PUB.Add;
577: END IF;
578: Set_Return_Status(x_orig_status => x_return_status,
579: p_new_status => FND_API.G_RET_STS_ERROR);

Line 587: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');

583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:
585: WHEN gl_currency_api.NO_RATE THEN
586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
587: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');
588: FND_MSG_PUB.ADD;
589: END IF;
590: Set_Return_Status(x_orig_status => x_return_status,
591: p_new_status => FND_API.G_RET_STS_ERROR);

Line 596: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');

592: x_return_status := FND_API.G_RET_STS_ERROR ;
593:
594: WHEN gl_currency_api.INVALID_CURRENCY THEN
595: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
596: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');
597: FND_MSG_PUB.ADD;
598: END IF;
599: Set_Return_Status(x_orig_status => x_return_status,
600: p_new_status => FND_API.G_RET_STS_ERROR);

Line 606: FND_MESSAGE.SET_NAME('FUN', 'ERROR_IN_IS_INIT_TRX_AMT_VALID'); -- Problem here: Remove check

602:
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
605: WHEN OTHERS THEN
606: FND_MESSAGE.SET_NAME('FUN', 'ERROR_IN_IS_INIT_TRX_AMT_VALID'); -- Problem here: Remove check
607: FND_MSG_PUB.ADD;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF FND_MSG_PUB.Check_Msg_Level
610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 701: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');

697: and (legal_entity_id = p_le_id or legal_entity_id is null);
698:
699: IF(l_count<1) THEN
700: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
701: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
702: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
703: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
704: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
705: FND_MSG_PUB.Add;

Line 702: FND_MESSAGE.SET_TOKEN('LE', g_le_name);

698:
699: IF(l_count<1) THEN
700: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
701: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
702: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
703: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
704: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
705: FND_MSG_PUB.Add;
706: Set_Return_Status(x_orig_status => x_return_status,

Line 703: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);

699: IF(l_count<1) THEN
700: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
701: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
702: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
703: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
704: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
705: FND_MSG_PUB.Add;
706: Set_Return_Status(x_orig_status => x_return_status,
707: p_new_status => FND_API.G_RET_STS_ERROR);

Line 704: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);

700: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
701: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
702: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
703: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
704: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
705: FND_MSG_PUB.Add;
706: Set_Return_Status(x_orig_status => x_return_status,
707: p_new_status => FND_API.G_RET_STS_ERROR);
708: END IF;

Line 714: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_CCID');

710: Debug('IS_CCID_VALID(-)');
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
714: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_CCID');
715: FND_MSG_PUB.Add;
716: END IF;
717:
718:

Line 752: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_CCID');

748: IF dbms_sql.fetch_rows(l_cur_hdl) > 0 THEN
749: dbms_sql.column_value(l_cur_hdl, 1, l_bal_seg_value);
750: ELSE
751: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
752: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_CCID');
753: FND_MSG_PUB.Add;
754: END IF;
755: Set_Return_Status(x_orig_status => x_return_status,
756: p_new_status => FND_API.G_RET_STS_ERROR);

Line 763: FND_MESSAGE.SET_NAME('FUN', 'UNEXP_ERROR_OCCURRED_IN_CCID_CHK');

759: OPEN bsv_csr;
760: FETCH bsv_csr INTO l_count;
761: IF l_count < 1 THEN
762: IF FND_MSG_PUB.Check_Msg_Level(FND_API.G_RET_STS_UNEXP_ERROR) THEN
763: FND_MESSAGE.SET_NAME('FUN', 'UNEXP_ERROR_OCCURRED_IN_CCID_CHK');
764: FND_MSG_PUB.Add;
765: END IF;
766: Set_Return_Status(x_orig_status => x_return_status,
767: p_new_status => FND_API.G_RET_STS_UNEXP_ERROR);

Line 775: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');

771: EXCEPTION
772: WHEN OTHERS THEN
773: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
774: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
775: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
776: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
777: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
778: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
779: FND_MSG_PUB.Add;

Line 776: FND_MESSAGE.SET_TOKEN('LE', g_le_name);

772: WHEN OTHERS THEN
773: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
774: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
775: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
776: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
777: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
778: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
779: FND_MSG_PUB.Add;
780: END IF;

Line 777: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);

773: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
774: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
775: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
776: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
777: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
778: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
779: FND_MSG_PUB.Add;
780: END IF;
781: */

Line 778: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);

774: Get_Valid_Bsvs(p_ledger_id => p_ledger_id,p_le_id => p_le_id,x_valid_bsvs => l_valid_bsvs);
775: FND_MESSAGE.SET_NAME('FUN', 'FUN_BSV_LE_NOT_ASSIGNED');
776: FND_MESSAGE.SET_TOKEN('LE', g_le_name);
777: FND_MESSAGE.SET_TOKEN('BSV', l_bal_seg_value);
778: FND_MESSAGE.SET_TOKEN('VALIDBSVS', l_valid_bsvs);
779: FND_MSG_PUB.Add;
780: END IF;
781: */
782: END;

Line 860: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_REC_DIST');

856: END IF;
857: IF (l_pay_dist_total_cr <> l_dist_line_total_dr OR
858: l_pay_dist_total_dr <> l_dist_line_total_cr) THEN
859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
860: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_REC_DIST');
861: FND_MSG_PUB.Add;
862: END IF;
863: Set_Return_Status(x_orig_status => x_return_status,
864: p_new_status => FND_API.G_RET_STS_ERROR);

Line 871: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_SIGNS_TRX_LINE');

867: l_dist_lines_cr_type = l_dist_lines_dr_type OR
868: l_pay_dist_pos_type = l_pay_dist_neg_type OR
869: l_dist_lines_pos_type = l_dist_lines_neg_type THEN
870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
871: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_SIGNS_TRX_LINE');
872: FND_MSG_PUB.Add;
873: END IF;
874: Set_Return_Status(x_orig_status => x_return_status,
875: p_new_status => FND_API.G_RET_STS_ERROR);

Line 954: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_INI_DIST');

950: END IF;
951: IF (l_init_dist_total_cr <> l_dist_line_total_dr OR
952: l_init_dist_total_dr <> l_dist_line_total_cr) THEN
953: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
954: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_INI_DIST');
955: FND_MSG_PUB.Add;
956: END IF;
957: Set_Return_Status(x_orig_status => x_return_status,
958: p_new_status => FND_API.G_RET_STS_ERROR);

Line 965: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_SIGNS_TRX_LINE');

961: l_dist_lines_cr_type = l_dist_lines_dr_type OR
962: l_init_dist_pos_type = l_init_dist_neg_type OR
963: l_dist_lines_pos_type = l_dist_lines_neg_type THEN
964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
965: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_SIGNS_TRX_LINE');
966: FND_MSG_PUB.Add;
967: END IF;
968: Set_Return_Status(x_orig_status => x_return_status,
969: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1081: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_INI_DIST');

1077: IF (p_validate_dist = 'Y') AND (l_trx_total_cr <> l_init_dist_total_dr OR
1078: l_trx_total_dr <> l_init_dist_total_cr )
1079: THEN
1080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1081: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_INI_DIST');
1082: FND_MSG_PUB.Add;
1083: END IF;
1084: Set_Return_Status(x_orig_status => x_return_status,
1085: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1093: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_SIGNS_TRX_LINE');

1089: l_trx_pos_type = l_trx_neg_type
1090: THEN
1091: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1092: THEN
1093: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_SIGNS_TRX_LINE');
1094: FND_MSG_PUB.Add;
1095: END IF;
1096: Set_Return_Status(x_orig_status => x_return_status,
1097: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1140: FND_MESSAGE.SET_NAME('FUN', 'FUN_CUR_NOTEQUAL_ENTRD_CUR');

1136: l_conv_type := p_exchange_rate_type;
1137: IF l_default_currency IS NOT NULL THEN
1138: IF p_curr_code <> l_default_currency THEN
1139: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1140: FND_MESSAGE.SET_NAME('FUN', 'FUN_CUR_NOTEQUAL_ENTRD_CUR');
1141: FND_MSG_PUB.Add;
1142: END IF;
1143: Set_Return_Status(x_orig_status => x_return_status,
1144: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1154: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');

1150: FETCH currency_csr INTO l_count;
1151: CLOSE currency_csr;
1152: IF l_count < 1 THEN
1153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1154: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');
1155: FND_MSG_PUB.Add;
1156: END IF;
1157: Set_Return_Status(x_orig_status => x_return_status,
1158: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1166: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');

1162: FETCH currency_rate_csr INTO l_count;
1163: CLOSE currency_rate_csr;
1164: IF l_count < 1 THEN
1165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1166: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');
1167: FND_MSG_PUB.Add;
1168: END IF;
1169: Set_Return_Status(x_orig_status => x_return_status,
1170: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1177: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');

1173: l_rate := GL_CURRENCY_API.Get_Rate_Sql(p_ledger_id, p_curr_code, p_trx_date, l_conv_type);
1174:
1175: IF l_rate = -1 THEN
1176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1177: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CONV_RATE_NOT_FOUND');
1178: FND_MSG_PUB.Add;
1179: END IF;
1180: ELSIF l_rate = -2 THEN
1181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1182: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');

1178: FND_MSG_PUB.Add;
1179: END IF;
1180: ELSIF l_rate = -2 THEN
1181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1182: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CURRENCY');
1183: FND_MSG_PUB.Add;
1184: END IF;
1185: END IF;
1186: Debug('IS_CURR_FLD_VALID(-)');

Line 1207: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_IC_RELATIONSHIP');

1203: l_count := p_trx_tbl.COUNT;
1204: WHILE l_count <> 0 AND i <= l_count LOOP
1205: IF p_from_le_id = p_trx_tbl(i).to_le_id THEN
1206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1207: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_IC_RELATIONSHIP');
1208: FND_MSG_PUB.Add;
1209: END IF;
1210: Set_Return_Status(x_orig_status => x_return_status,
1211: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1236: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_DUPLICATE_RECP');

1232: WHILE l_count <> 0 AND j <= l_count LOOP
1233: IF p_trx_tbl(i).recipient_id = p_initiator_id
1234: OR p_trx_tbl(i).recipient_id = p_trx_tbl(j).recipient_id THEN
1235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1236: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_DUPLICATE_RECP');
1237: FND_MSG_PUB.Add;
1238: END IF;
1239: Set_Return_Status(x_orig_status => x_return_status,
1240: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1267: FND_MESSAGE.SET_NAME('FUN','FUN_API_INVALID_TRX_TYPE');

1263: l_need_invoice,
1264: l_enabled);
1265: IF l_enabled = 'N' THEN
1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1267: FND_MESSAGE.SET_NAME('FUN','FUN_API_INVALID_TRX_TYPE');
1268: FND_MSG_PUB.Add;
1269: END IF;
1270: Set_Return_Status(x_orig_status => x_return_status,
1271: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1318: FND_MESSAGE.SET_NAME('FUN', 'FUN_PERIOD_NOT_OPEN');

1314: FETCH period_open_csr INTO l_count;
1315: CLOSE period_open_csr;
1316: IF l_count < 1 THEN
1317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1318: FND_MESSAGE.SET_NAME('FUN', 'FUN_PERIOD_NOT_OPEN');
1319: FND_MSG_PUB.Add;
1320: END IF;
1321: Set_Return_Status(x_orig_status => x_return_status,
1322: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1328: FND_MESSAGE.SET_NAME('FUN', 'FUN_PERIOD_NOT_OPEN');

1324: */
1325: l_result := fun_period_status_pkg.get_fun_prd_status(p_gl_date, p_trx_type_id);
1326: IF l_result <> 'O' THEN
1327: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1328: FND_MESSAGE.SET_NAME('FUN', 'FUN_PERIOD_NOT_OPEN');
1329: FND_MSG_PUB.Add;
1330: END IF;
1331: Set_Return_Status(x_orig_status => x_return_status,
1332: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1412: FND_MESSAGE.SET_NAME('FUN', 'FUN_REQUIRED_FIELDS_INCOMPLETE');

1408: p_batch_rec.batch_date IS NULL) THEN
1409: Set_Return_Status(x_orig_status => x_return_status,
1410: p_new_status => FND_API.G_RET_STS_ERROR);
1411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1412: FND_MESSAGE.SET_NAME('FUN', 'FUN_REQUIRED_FIELDS_INCOMPLETE');
1413: FND_MSG_PUB.Add;
1414: END IF;
1415: END IF;
1416: IF (nvl(p_insert,FND_API.G_TRUE) = FND_API.G_TRUE) THEN

Line 1511: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTERCOMPANY_EXCEPTION');

1507: END IF;
1508:
1509: if(l_intercompany_exception = 'N') THEN
1510:
1511: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTERCOMPANY_EXCEPTION');
1512: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);
1513: FND_MSG_PUB.Add;
1514: Set_Return_Status(x_orig_status => x_return_status,
1515: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1512: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);

1508:
1509: if(l_intercompany_exception = 'N') THEN
1510:
1511: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTERCOMPANY_EXCEPTION');
1512: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);
1513: FND_MSG_PUB.Add;
1514: Set_Return_Status(x_orig_status => x_return_status,
1515: p_new_status => FND_API.G_RET_STS_ERROR);
1516: end if;

Line 1560: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');

1556: IF l_creation_sign IS NULL THEN
1557: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1558: IF l_trx_type = 'INV' THEN
1559:
1560: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
1561: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
1562: ELSE
1563:
1564: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');

Line 1561: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');

1557: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1558: IF l_trx_type = 'INV' THEN
1559:
1560: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
1561: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
1562: ELSE
1563:
1564: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
1565: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');

Line 1564: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');

1560: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
1561: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
1562: ELSE
1563:
1564: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
1565: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');
1566: END IF;
1567: FND_MSG_PUB.Add;
1568: END IF;

Line 1565: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');

1561: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
1562: ELSE
1563:
1564: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
1565: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');
1566: END IF;
1567: FND_MSG_PUB.Add;
1568: END IF;
1569: Set_Return_Status(x_orig_status => x_return_status,

Line 1578: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_TYPE_POS_AMT');

1574: negative, then throw an error*/
1575: IF (p_trx_tbl(i).init_amount_cr > 0 or p_trx_tbl(i).init_amount_dr < 0)
1576: and l_creation_sign = 1 THEN
1577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1578: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_TYPE_POS_AMT');
1579: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);
1580: FND_MSG_PUB.Add;
1581: END IF;
1582: Set_Return_Status(x_orig_status => x_return_status,

Line 1579: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);

1575: IF (p_trx_tbl(i).init_amount_cr > 0 or p_trx_tbl(i).init_amount_dr < 0)
1576: and l_creation_sign = 1 THEN
1577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1578: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_TYPE_POS_AMT');
1579: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);
1580: FND_MSG_PUB.Add;
1581: END IF;
1582: Set_Return_Status(x_orig_status => x_return_status,
1583: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1590: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_TYPE_NEG_AMT');

1586: positive, then throw an error*/
1587: IF (p_trx_tbl(i).init_amount_dr > 0 or p_trx_tbl(i).init_amount_cr < 0)
1588: and l_creation_sign = -1 THEN
1589: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_TYPE_NEG_AMT');
1591: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);
1592: FND_MSG_PUB.Add;
1593: END IF;
1594: Set_Return_Status(x_orig_status => x_return_status,

Line 1591: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);

1587: IF (p_trx_tbl(i).init_amount_dr > 0 or p_trx_tbl(i).init_amount_cr < 0)
1588: and l_creation_sign = -1 THEN
1589: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1590: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_TYPE_NEG_AMT');
1591: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_tbl(i).trx_number);
1592: FND_MSG_PUB.Add;
1593: END IF;
1594: Set_Return_Status(x_orig_status => x_return_status,
1595: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1635: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_RECI_LINE_NOT_FOUND');

1631: -- 7.2.2.6 Note: Do not need to check at least 1 dist line
1632: -- as we check total trx amounts = total dist amounts
1633: IF p_trx_tbl.count < 1 THEN
1634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1635: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_RECI_LINE_NOT_FOUND');
1636: -- Problem: Double check with msg repository
1637: FND_MSG_PUB.Add;
1638: END IF;
1639: Set_Return_Status(x_orig_status => x_return_status,

Line 1749: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_NUM_NULL');

1745: IF p_trx_rec.trx_number IS NULL THEN
1746: Set_Return_Status(x_orig_status => x_return_status,
1747: p_new_status => FND_API.G_RET_STS_ERROR);
1748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1749: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_NUM_NULL');
1750: FND_MSG_PUB.Add;
1751: END IF;
1752: END IF;
1753: --Bug No. 5307996. Check for valid Currency code.

Line 1759: FND_MESSAGE.SET_NAME('FUN', 'FUN_ADI_INVALID_CURRENCY');

1755: --Bug No. 6311049.
1756: Set_Return_Status(x_orig_status => x_return_status,
1757: p_new_status => FND_API.G_RET_STS_ERROR);
1758: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1759: FND_MESSAGE.SET_NAME('FUN', 'FUN_ADI_INVALID_CURRENCY');
1760: FND_MESSAGE.SET_TOKEN('CURRENCY', default_currency_code);
1761: FND_MSG_PUB.Add;
1762: END IF;
1763: END IF;

Line 1760: FND_MESSAGE.SET_TOKEN('CURRENCY', default_currency_code);

1756: Set_Return_Status(x_orig_status => x_return_status,
1757: p_new_status => FND_API.G_RET_STS_ERROR);
1758: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1759: FND_MESSAGE.SET_NAME('FUN', 'FUN_ADI_INVALID_CURRENCY');
1760: FND_MESSAGE.SET_TOKEN('CURRENCY', default_currency_code);
1761: FND_MSG_PUB.Add;
1762: END IF;
1763: END IF;
1764: --End of Bug No. 5307996.

Line 1779: FND_MESSAGE.SET_NAME('FUN', 'FUN_NON_ZERO_AMOUNT');

1775: Set_Return_Status(x_orig_status => x_return_status,
1776: p_new_status => FND_API.G_RET_STS_ERROR);
1777: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1778: IF(p_trx_rec.init_amount_dr=0) THEN
1779: FND_MESSAGE.SET_NAME('FUN', 'FUN_NON_ZERO_AMOUNT');
1780: FND_MSG_PUB.Add;
1781: ELSE
1782: FND_MESSAGE.SET_NAME('FUN', 'FUN_REQUIRED_FIELDS_INCOMPLETE');
1783: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_rec.trx_number);

Line 1782: FND_MESSAGE.SET_NAME('FUN', 'FUN_REQUIRED_FIELDS_INCOMPLETE');

1778: IF(p_trx_rec.init_amount_dr=0) THEN
1779: FND_MESSAGE.SET_NAME('FUN', 'FUN_NON_ZERO_AMOUNT');
1780: FND_MSG_PUB.Add;
1781: ELSE
1782: FND_MESSAGE.SET_NAME('FUN', 'FUN_REQUIRED_FIELDS_INCOMPLETE');
1783: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_rec.trx_number);
1784: FND_MSG_PUB.Add;
1785: END IF;
1786: END IF;

Line 1783: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_rec.trx_number);

1779: FND_MESSAGE.SET_NAME('FUN', 'FUN_NON_ZERO_AMOUNT');
1780: FND_MSG_PUB.Add;
1781: ELSE
1782: FND_MESSAGE.SET_NAME('FUN', 'FUN_REQUIRED_FIELDS_INCOMPLETE');
1783: FND_MESSAGE.SET_TOKEN('TRX_NUMBER',p_trx_rec.trx_number);
1784: FND_MSG_PUB.Add;
1785: END IF;
1786: END IF;
1787: END IF;

Line 1794: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CHANGE_INITIATOR');

1790: IF p_trx_rec.recipient_id=p_trx_rec.initiator_id THEN
1791: Set_Return_Status(x_orig_status => x_return_status,
1792: p_new_status => FND_API.G_RET_STS_ERROR);
1793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1794: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_CHANGE_INITIATOR');
1795: FND_MSG_PUB.Add;
1796: END IF;
1797: END IF;
1798:

Line 1853: FND_MESSAGE.SET_NAME('FUN', 'FND_INTER_TRX_GLDATE');

1849: p_to_le_id => p_trx_rec.to_le_id,
1850: p_trx_date => p_gl_date);
1851:
1852: IF l_return_status like 'L' THEN -- 6145670
1853: FND_MESSAGE.SET_NAME('FUN', 'FND_INTER_TRX_GLDATE');
1854: FND_MSG_PUB.Add;
1855: Set_Return_Status(x_orig_status => x_return_status, p_new_status => FND_API.G_RET_STS_ERROR);
1856:
1857: END IF; -- 6145670

Line 1945: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');

1941:
1942: IF p_init_dist_rec.ccid IS NULL OR p_init_dist_rec.ccid <= 0 THEN
1943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1944: --Bug: 6618396
1945: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');
1946: -- Problem: Double check with msg repository
1947: FND_MSG_PUB.Add;
1948: END IF;
1949: Set_Return_Status(x_orig_status => x_return_status,

Line 1968: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');

1964: p_init_dist_rec.amount_dr <> 0))
1965: OR
1966: p_init_dist_rec.line_number IS NULL THEN
1967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1968: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');
1969: FND_MSG_PUB.Add;
1970: END IF;
1971: Set_Return_Status(x_orig_status => x_return_status,
1972: p_new_status => FND_API.G_RET_STS_ERROR);

Line 1979: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMPLETE_DIST_ACCTN');

1975: --IF nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL)>= FND_API.G_VALID_LEVEL_FULL THEN
1976:
1977: IF p_init_dist_rec.ccid IS NULL OR p_init_dist_rec.ccid <= 0 THEN
1978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1979: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMPLETE_DIST_ACCTN');
1980: FND_MSG_PUB.Add;
1981: END IF;
1982: Set_Return_Status(x_orig_status => x_return_status,
1983: p_new_status => FND_API.G_RET_STS_ERROR);

Line 2065: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');

2061:
2062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2063: Print ('Debug Init_Dist_Val >>> In If 3' );
2064: --Bug: 6618396
2065: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');
2066: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);
2067: -- Problem: Double check with msg repository
2068: FND_MSG_PUB.Add;
2069:

Line 2066: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);

2062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2063: Print ('Debug Init_Dist_Val >>> In If 3' );
2064: --Bug: 6618396
2065: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');
2066: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);
2067: -- Problem: Double check with msg repository
2068: FND_MSG_PUB.Add;
2069:
2070: Print ('Debug Init_Dist_Val >>> End of If 3' );

Line 2103: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_DIST_LINE');

2099: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2100:
2101: Print ('Debug Init_Dist_Val >>> In If 22' );
2102:
2103: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_DIST_LINE');
2104: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);
2105: FND_MSG_PUB.Add;
2106: END IF;
2107:

Line 2104: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);

2100:
2101: Print ('Debug Init_Dist_Val >>> In If 22' );
2102:
2103: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_DIST_LINE');
2104: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);
2105: FND_MSG_PUB.Add;
2106: END IF;
2107:
2108: Print ('Debug Init_Dist_Val >>> End If 22' );

Line 2120: FND_MESSAGE.SET_NAME('FUN', 'Party type for distributions has not been set correctly');

2116: Print ('Debug Init_Dist_Val >>> FND_API.G_RET_STS_ERROR ' || FND_API.G_RET_STS_ERROR );
2117:
2118: IF p_dist_line_rec.party_type <> 'I' and p_dist_line_rec.party_type <> 'R' THEN
2119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('FUN', 'Party type for distributions has not been set correctly');
2121: END IF;
2122: Set_Return_Status(x_orig_status => x_return_status,
2123: p_new_status => FND_API.G_RET_STS_ERROR);
2124: END IF;

Line 2133: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');

2129: --IF nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL)>= FND_API.G_VALID_LEVEL_FULL THEN
2130: IF p_dist_line_rec.ccid IS NULL OR p_dist_line_rec.ccid <= 0 THEN
2131: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2132: --Bug: 6618396
2133: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');
2134: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);
2135: END IF;
2136:
2137: Print ('Debug Init_Dist_Val >>> x_return_status' || x_return_status );

Line 2134: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);

2130: IF p_dist_line_rec.ccid IS NULL OR p_dist_line_rec.ccid <= 0 THEN
2131: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2132: --Bug: 6618396
2133: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_INIT_DIST_AC_CCID');
2134: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_line_rec.trx_number);
2135: END IF;
2136:
2137: Print ('Debug Init_Dist_Val >>> x_return_status' || x_return_status );
2138: Set_Return_Status(x_orig_status => x_return_status,

Line 2244: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');

2240:
2241: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);
2242: IF l_from_ou_id IS NULL THEN
2243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2244: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
2245: FND_MSG_PUB.Add;
2246: END IF;
2247: Set_Return_Status(x_orig_status => x_return_status,
2248: p_new_status => FND_API.G_RET_STS_ERROR);

Line 2256: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');

2252: FETCH ou_valid_csr INTO l_count;
2253: CLOSE ou_valid_csr;
2254: IF l_count < 1 THEN
2255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2256: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
2257: FND_MSG_PUB.Add;
2258: END IF;
2259: Set_Return_Status(x_orig_status => x_return_status,
2260: p_new_status => FND_API.G_RET_STS_ERROR);

Line 2287: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CUSTOMER');

2283: FROM hz_parties
2284: WHERE party_id=p_recipient_id;
2285:
2286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CUSTOMER');
2288: FND_MESSAGE.SET_TOKEN('INITIATOR_NAME',initiator_name);
2289: FND_MESSAGE.SET_TOKEN('RECIPIENT_NAME',recipient_name);
2290: FND_MSG_PUB.Add;
2291: END IF;

Line 2288: FND_MESSAGE.SET_TOKEN('INITIATOR_NAME',initiator_name);

2284: WHERE party_id=p_recipient_id;
2285:
2286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CUSTOMER');
2288: FND_MESSAGE.SET_TOKEN('INITIATOR_NAME',initiator_name);
2289: FND_MESSAGE.SET_TOKEN('RECIPIENT_NAME',recipient_name);
2290: FND_MSG_PUB.Add;
2291: END IF;
2292: Set_Return_Status(x_orig_status => x_return_status,

Line 2289: FND_MESSAGE.SET_TOKEN('RECIPIENT_NAME',recipient_name);

2285:
2286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_CUSTOMER');
2288: FND_MESSAGE.SET_TOKEN('INITIATOR_NAME',initiator_name);
2289: FND_MESSAGE.SET_TOKEN('RECIPIENT_NAME',recipient_name);
2290: FND_MSG_PUB.Add;
2291: END IF;
2292: Set_Return_Status(x_orig_status => x_return_status,
2293: p_new_status => FND_API.G_RET_STS_ERROR);

Line 2421: FND_MESSAGE.SET_NAME('FUN', 'FUN_REVERSED_BATCH'); -- Problem here: Whether a msg is needed

2417: )
2418: );
2419: IF l_initiator_id < 1 THEN
2420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2421: FND_MESSAGE.SET_NAME('FUN', 'FUN_REVERSED_BATCH'); -- Problem here: Whether a msg is needed
2422: FND_MSG_PUB.Add;
2423: END IF;
2424: Set_Return_Status(x_orig_status => x_return_status,
2425: p_new_status => FND_API.G_RET_STS_ERROR);

Line 2945: FND_MESSAGE.SET_NAME('FUN', 'Trx error'); -- Problem here: Whether a msg is needed

2941: AND headers.original_trx_id IS NULL
2942: AND headers.status in ('COMPLETE', 'APPROVED');--Bug: 6625360. AND headers.status = 'COMPLETE';
2943: IF l_initiator_id IS NULL THEN
2944: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2945: FND_MESSAGE.SET_NAME('FUN', 'Trx error'); -- Problem here: Whether a msg is needed
2946: FND_MSG_PUB.Add;
2947: END IF;
2948: Set_Return_Status(x_orig_status => x_return_status,
2949: p_new_status => FND_API.G_RET_STS_ERROR);

Line 3476: FND_MESSAGE.SET_NAME('FUN', 'Can not update status given');

3472: COMMIT WORK;
3473: END IF;
3474: ELSE
3475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3476: FND_MESSAGE.SET_NAME('FUN', 'Can not update status given');
3477: FND_MSG_PUB.Add;
3478: END IF;
3479: Set_Return_Status(x_orig_status => x_return_status,
3480: p_new_status => FND_API.G_RET_STS_ERROR);

Line 3550: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_RECI_DIST_AC_CCID');

3546: IF p_dist_lines_tbl(i).party_type = 'R' THEN
3547: IF p_dist_lines_tbl(i).ccid IS NULL THEN
3548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3549: --Bug: 6618396
3550: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_RECI_DIST_AC_CCID');
3551: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_lines_tbl(i).trx_number);
3552: -- Problem: Double check with msg repository
3553: FND_MSG_PUB.Add;
3554: END IF;

Line 3551: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_lines_tbl(i).trx_number);

3547: IF p_dist_lines_tbl(i).ccid IS NULL THEN
3548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3549: --Bug: 6618396
3550: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_RECI_DIST_AC_CCID');
3551: FND_MESSAGE.SET_TOKEN('TRX_NUMBER', p_dist_lines_tbl(i).trx_number);
3552: -- Problem: Double check with msg repository
3553: FND_MSG_PUB.Add;
3554: END IF;
3555: Set_Return_Status(x_orig_status => x_return_status,

Line 3612: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');

3608:
3609: --Bug: 16229717.
3610: IF p_dist_lines_tbl(j).amount_cr is null AND p_dist_lines_tbl(j).amount_dr is null THEN
3611:
3612: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');
3613: FND_MSG_PUB.Add;
3614: Set_Return_Status(x_orig_status => x_return_status,
3615: p_new_status => FND_API.G_RET_STS_ERROR);
3616: Return;

Line 3646: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_REC_DIST');

3642: IF (p_trx_amount_cr <> l_dist_total_dr OR
3643: p_trx_amount_dr <> l_dist_total_cr )
3644: THEN
3645: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3646: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_REC_DIST');
3647: FND_MSG_PUB.Add;
3648: END IF;
3649: Set_Return_Status(x_orig_status => x_return_status,
3650: p_new_status => FND_API.G_RET_STS_ERROR);

Line 3657: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');

3653: IF l_dist_cr_type = l_dist_dr_type
3654: THEN
3655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3656: THEN
3657: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');
3658: FND_MSG_PUB.Add;
3659: END IF;
3660: Set_Return_Status(x_orig_status => x_return_status,
3661: p_new_status => FND_API.G_RET_STS_ERROR);

Line 3749: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_ENTRY_TRX_UP_NODATA');

3745: END LOOP;
3746: END IF;
3747: IF l_index = 0 THEN
3748: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3749: FND_MESSAGE.SET_NAME('FUN', 'FUN_TRX_ENTRY_TRX_UP_NODATA');
3750: FND_MSG_PUB.Add;
3751: END IF;
3752: -- Made changes for bug 9341446
3753: Set_Return_Status(x_orig_status => x_return_status,

Line 3938: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');

3934:
3935: --Bug: 16229717.
3936: IF p_dist_lines_tbl(j).amount_cr is null AND p_dist_lines_tbl(j).amount_dr is null THEN
3937:
3938: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');
3939: FND_MSG_PUB.Add;
3940: Set_Return_Status(x_orig_status => x_return_status,
3941: p_new_status => FND_API.G_RET_STS_ERROR);
3942: Return;

Line 3973: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_REC_DIST');

3969: IF (nvl(p_trx_amount_cr,0) < l_dist_total_dr OR
3970: nvl(p_trx_amount_dr,0) < l_dist_total_cr )
3971: THEN
3972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3973: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INCOMLT_SUM_REC_DIST');
3974: FND_MSG_PUB.Add;
3975: END IF;
3976: Set_Return_Status(x_orig_status => x_return_status,
3977: p_new_status => FND_API.G_RET_STS_ERROR);

Line 3984: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');

3980: IF l_dist_cr_type = l_dist_dr_type
3981: THEN
3982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3983: THEN
3984: FND_MESSAGE.SET_NAME('FUN', 'FUN_INVALID_DRCR_BDIST_LINE');
3985: FND_MSG_PUB.Add;
3986: END IF;
3987: Set_Return_Status(x_orig_status => x_return_status,
3988: p_new_status => FND_API.G_RET_STS_ERROR);

Line 4548: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');

4544: -- 7.3.1.3
4545: l_to_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_recipient_id, p_trx_date);
4546: IF l_to_ou_id IS NULL THEN
4547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4548: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4549: FND_MSG_PUB.Add;
4550: END IF;
4551: Set_Return_Status(x_orig_status => x_return_status,
4552: p_new_status => FND_API.G_RET_STS_ERROR);

Line 4560: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');

4556: FETCH ou_valid_csr INTO l_count;
4557: CLOSE ou_valid_csr;
4558: IF l_count < 1 THEN
4559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4560: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4561: FND_MSG_PUB.Add;
4562: END IF;
4563: Set_Return_Status(x_orig_status => x_return_status,
4564: p_new_status => FND_API.G_RET_STS_ERROR);

Line 4580: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');

4576:
4577: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);
4578: IF l_from_ou_id IS NULL THEN
4579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4580: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_OU');
4581: FND_MSG_PUB.Add;
4582: END IF;
4583: Set_Return_Status(x_orig_status => x_return_status,
4584: p_new_status => FND_API.G_RET_STS_ERROR);

Line 4597: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_SUPPLIER');

4593: l_supplier_id, l_pay_site_id);
4594:
4595: IF NOT l_success THEN
4596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4597: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_INVALID_SUPPLIER');
4598: FND_MSG_PUB.Add;
4599: END IF;
4600: Set_Return_Status(x_orig_status => x_return_status,
4601: p_new_status => FND_API.G_RET_STS_ERROR);

Line 4609: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_AP_PERIOD_NOT_OPEN');

4605: FETCH period_open_csr INTO l_count;
4606: CLOSE period_open_csr;
4607: IF l_count < 1 THEN
4608: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4609: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_AP_PERIOD_NOT_OPEN');
4610: FND_MSG_PUB.Add;
4611: END IF;
4612: Set_Return_Status(x_orig_status => x_return_status,
4613: p_new_status => FND_API.G_RET_STS_ERROR);

Line 4730: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');

4726: if( l_init_amount_dr < 0 OR l_init_amount_cr > 0) THEN
4727: l_trx_type := 'CM';
4728: END IF;
4729:
4730: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
4731: IF l_trx_type = 'INV' THEN
4732: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
4733: ELSE
4734: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');

Line 4732: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');

4728: END IF;
4729:
4730: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
4731: IF l_trx_type = 'INV' THEN
4732: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
4733: ELSE
4734: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');
4735: END IF;
4736: FND_MSG_PUB.Add;

Line 4734: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');

4730: FND_MESSAGE.SET_NAME('FUN', 'FUN_NO_TRX_TYPE_MAP');
4731: IF l_trx_type = 'INV' THEN
4732: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Invoice Type');
4733: ELSE
4734: FND_MESSAGE.SET_TOKEN('TRX_TYPE','Credit Memo Type');
4735: END IF;
4736: FND_MSG_PUB.Add;
4737: END IF;
4738: Set_Return_Status(x_orig_status => x_return_status, p_new_status => FND_API.G_RET_STS_ERROR);

Line 4746: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_AR_PERIOD_NOT_OPEN');

4742: l_from_ledger_id);
4743: FETCH period_open_csr INTO l_count;
4744: IF l_count < 1 THEN
4745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4746: FND_MESSAGE.SET_NAME('FUN', 'FUN_API_AR_PERIOD_NOT_OPEN');
4747: FND_MSG_PUB.Add;
4748: END IF;
4749: Set_Return_Status(x_orig_status => x_return_status, p_new_status => FND_API.G_RET_STS_ERROR);
4750: END IF;

Line 4795: FND_MESSAGE.SET_NAME('FUN', p_message);

4791: BEGIN
4792: -- API body
4793: -- Problem: Use FND LOGGING mechanism?
4794: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
4795: FND_MESSAGE.SET_NAME('FUN', p_message);
4796: FND_MSG_PUB.Add;
4797: END IF;
4798:
4799: -- End of API body.