DBA Data[Home] [Help]

APPS.GMS_PA_API dependencies on PA_CC_UTILS

Line 67: pa_cc_utils.log_message('GMS_PA_API.get_award_id : Unexpected error : '||SQLERRM,1);

63: WHEN OTHERS THEN
64: IF C_get_award_id%ISOPEN THEN
65: close C_get_award_id ;
66: END IF ;
67: pa_cc_utils.log_message('GMS_PA_API.get_award_id : Unexpected error : '||SQLERRM,1);
68: return 0;
69: END get_award_id ;
70:
71: -- ========================================================================================================

Line 1443: pa_cc_utils.log_message('GMS: Resource mapping failed for packet :'||to_char(x_packet_id),1);

1439:
1440: x_temp := NULL ;
1441:
1442: IF NVL(x_err_code, 0) <> 0 THEN
1443: pa_cc_utils.log_message('GMS: Resource mapping failed for packet :'||to_char(x_packet_id),1);
1444: raise_application_error( -20000, SQLERRM(X_ERR_CODE) ) ;
1445: END IF ;
1446:
1447: SELECT count(*)

Line 1459: pa_cc_utils.log_message('GMS: Resource mapping failed for packet :'||to_char(x_packet_id),1);

1455: gms_error_pkg.gms_debug('GMS:vert_trx_interface END TIME :'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 'C');
1456: END IF;
1457:
1458: IF x_err_code > 0 THEN
1459: pa_cc_utils.log_message('GMS: Resource mapping failed for packet :'||to_char(x_packet_id),1);
1460: raise_application_error( -20000, 'GMS: Resource mapping failed for packet :'||to_char(x_packet_id) ) ;
1461: END IF ;
1462:
1463: EXCEPTION

Line 1682: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - START' ,1);

1678: BEGIN
1679:
1680: L_DEBUG := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');
1681:
1682: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - START' ,1);
1683: IF X_status is not NULL then
1684: RETURN ;
1685: END IF ;
1686: -- -------------------------------------------------

Line 1837: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - calling get_valid_awards') ;

1833: -- Bug 5237650
1834: -- R12.PJ:XB4:DEV:APL:EXP ITEM DATE VALIDATIONS FOR SUPPLIER COST.
1835: --
1836: IF l_award_id is not null then
1837: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - calling get_valid_awards') ;
1838:
1839: open get_valid_awards ;
1840: fetch get_valid_awards into c_award_rec ;
1841: close get_valid_awards ;

Line 1843: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - EI Date validations') ;

1839: open get_valid_awards ;
1840: fetch get_valid_awards into c_award_rec ;
1841: close get_valid_awards ;
1842:
1843: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - EI Date validations') ;
1844: IF txn_rec.expenditure_item_date < TRUNC(c_award_rec.preaward_date) THEN
1845: x_status := 'GMS_EXP_ITEM_DT_BEFORE_AWD_ST' ;
1846: ELSIF txn_rec.expenditure_item_date > TRUNC(c_award_rec.end_date) THEN
1847: x_status := 'GMS_EXP_ITEM_DT_AFTER_AWD_END' ;

Line 1851: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - EI Date validations :'||x_status) ;

1847: x_status := 'GMS_EXP_ITEM_DT_AFTER_AWD_END' ;
1848: ELSIF c_award_rec.close_date < TRUNC(SYSDATE) THEN
1849: x_status := 'GMS_AWARD_IS_CLOSED' ;
1850: END IF ;
1851: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - EI Date validations :'||x_status) ;
1852: END IF ;
1853: --
1854: -- Bug 5237650
1855: -- R12.PJ:XB4:DEV:APL:EXP ITEM DATE VALIDATIONS FOR SUPPLIER COST.

Line 1866: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - After calling get_award_id , value of award_id'

1862: x_status := 'GMS_AWARD_REQUIRED' ;
1863: ELSE
1864: txn_rec.award_id := get_award_id (txn_rec.award_id,txn_rec.award_number);
1865: l_award_id := txn_rec.award_id;
1866: pa_cc_utils.log_message( 'GMS_PA_API.VERT_APP_VALIDATE - After calling get_award_id , value of award_id'
1867: ||txn_rec.award_id ,1);
1868: IF NVL(txn_rec.award_id,0) = 0 then
1869: x_status := 'GMS_INVALID_AWARD';
1870: END IF;